Hello all,
I've studied Python and studied PostgreSQL. What is the absolute next
best step to take to merge these two finely together? I've heard of
SQLAlchemy and some others but before I dive in, I would really like
the opinion of those who tried it and other toolkits.
My main concern is, I would like to completely work with a database
from Python. What would you suggest I look into?
Thank you for your time!
6  1314 
I've studied Python and studied PostgreSQL.
Good.
>What is the absolute next best step to take to merge these two finely
together? I've heard of
Just download psycopg2. Python and PostgreSQL are a match made in heavan.
Make your connection,
do querys,
get data,
earn profits.
Object-Relational-Mappers are to direct SQL as phone sex is to the real
thing.
Harald
Hi,
Look at DJANGO ;-) http://www.djangoproject.com/ http://www.djangobook.com/
Regards
Peter Atkinson
vbgunz ha escrito:
Hello all,
I've studied Python and studied PostgreSQL. What is the absolute next
best step to take to merge these two finely together? I've heard of
SQLAlchemy and some others but before I dive in, I would really like
the opinion of those who tried it and other toolkits.
My main concern is, I would like to completely work with a database
from Python. What would you suggest I look into?
Thank you for your time!
On Fri, 01 Dec 2006 23:04:37 -0800, vbgunz wrote:
Hello all,
I've studied Python and studied PostgreSQL. What is the absolute next
best step to take to merge these two finely together? I've heard of
SQLAlchemy and some others but before I dive in, I would really like
the opinion of those who tried it and other toolkits.
My main concern is, I would like to completely work with a database
from Python. What would you suggest I look into?
Let me venture that the biggest problem most people seem to have is that
they endure great pain just to avoid learning SQL. SQL is a complete
programming language in and of itself with a breadth and depth that most
people miss. And it covers much terrain missed by Python. Which is a good
thing because SQL and Python are perfect together. With this language mix
you've got darn near everything licked.
Get SQL in your head and all you will need would be the db-api interface
with Postgres that Frederick Lundh pointed you to. All you want to do is
throw SQL commands at Postgres and recover result sets into Python.
It's a cinch.
Thomas Bartkus
Before commiting to a RDBMS take a look at Gadfly.
Depending on what you need a RDB for,
(light duty), or (heavy duty) take a look at
gadfly. Gadfly is made from all python code.
Use stardard SQL statements like Select, Create
and Drop Tables, etc.
Newest version GadflyB5 http://gadfly.sourceforge.net/
jim-on-linux http://www.inqvista.com
On Saturday 02 December 2006 11:33, Thomas Bartkus
wrote:
On Fri, 01 Dec 2006 23:04:37 -0800, vbgunz
wrote:
Hello all,
I've studied Python and studied PostgreSQL.
What is the absolute next best step to take
to merge these two finely together? I've
heard of SQLAlchemy and some others but
before I dive in, I would really like the
opinion of those who tried it and other
toolkits.
My main concern is, I would like to
completely work with a database from Python.
What would you suggest I look into?
Let me venture that the biggest problem most
people seem to have is that they endure great
pain just to avoid learning SQL. SQL is a
complete programming language in and of itself
with a breadth and depth that most people miss.
And it covers much terrain missed by Python.
Which is a good thing because SQL and Python
are perfect together. With this language mix
you've got darn near everything licked.
Get SQL in your head and all you will need
would be the db-api interface with Postgres
that Frederick Lundh pointed you to. All you
want to do is throw SQL commands at Postgres
and recover result sets into Python.
It's a cinch.
Thomas Bartkus
I need to thank you all for your suggestions and recommendations . I am
ultimately aiming to work in Python, PostgreSQL and Django and this
link http://www.sqlalchemy.org/news.myt#item_3 sort of made my day :)
I really appreciate all of your feedback and will go through Fredrik's
links as soon as I get the chance. I thank you all again, I appreciate
it very much! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Erik Johnson |
last post by:
This is somewhat a NEWBIE question...
My company maintains a small RDBS driven website. We currently generate
HTML using PHP. I've hacked a bit in Python, and generally think it is a
rather cool language. I've done Perl and like it, there are a few features
of PHP I like but overall am not too excited about it. I have found PHP's
strtotime() function to be quite flexible and handy and we make liberal use
of it.
I have not yet really...
|
by: Zunbeltz Izaola |
last post by:
Hi!
I am planning a program and I need some advice about what tool to use.
Basically my program will deal with a object A. A is a list like
object with same attributtes and a list of objects B. B is also a list
like object with attributes and a list of object C.
class A:
Name = ""
|
by: W. Borgert |
last post by:
Hi,
I'm not new to Python, but new to databases and PostgreSQL.
I like to write a PostgreSQL client application (not code
running inside of the RDBMS), and Debian has four modules:
python2.3-pgsql - A Python DB-API 2.0 interface to PostgreSQL v7.x
python2.3-popy - module providing access to PostgreSQL from Python2.3
python2.3-psycopg - Python 2.3 module for PostgreSQL
python2.3-pygresql - PostgreSQL module for Python
|
by: Marc G. Fournier |
last post by:
Well folks, we are now coming into the home stretch of another long
development cycle, and its time for more vigorous and extensive testing
....
Last night, we bundled up Beta4, which is the first one that we've
officially announced "publicly", with the other 3 having been only
announced on -hackers ...
This release, depending on the bug reports received, will most likely flow
into our first Release Candidate by end of next week, so...
|
by: Paul Mc Gee |
last post by:
hi everyone
i have just downloaded the latest version of
postgresql and was doing the installation according to
the article at
http://www.faqs.org/docs/ppbook/x486.htm when i got to
the point where the perl and python modules are to be
installed. the distribution used in that article is an
older version of postgresql and i cant seem to find
where the perl and python modules are in the current
release. when it didnt work for me i just...
| | |
by: Mike Cox |
last post by:
Obviously, there cannot be 21 postgresql groups in the comp.* hierarchy.
Many of the 21 are not used that often, and would not be of much popularity
to those on usenet.
I did a check on news.postgresql.org to see which newsgroups are the most
popular and also the ones which cover the relevant postgresql topics. Most
of the postgresql topics and traffic are represented in these four
newsgroups:
comp.databases.postgresql.admin
|
by: Adam Smith |
last post by:
Hello,
I am attempting to compile postgresql from source with python enable. I
have compiled & installed python on my machine according to the
instruction, installation seems fine
My Platform ==>
# uname -a
FreeBSD econ.com 4.9-STABLE FreeBSD 4.9-STABLE #0: Wed Nov 12
17:41:01 PST 2003
|
by: northband |
last post by:
Hi, I am interested in re-writing my website in Python vs PHP but have
a few questions. Here are my specs, please advise as to which
configuration would be best:
1.Dell Poweredge Server, w/IIS, currently Windows but considering
FreeBSD
2. Site consists of result pages for auctions and items for sale (100
per page)
3. MySQL (Dell Poweredge w/AMD) database server connected to my web
server
|
by: H J van Rooyen |
last post by:
Hi,
I want to write a small system that is transaction based.
I want to split the GUI front end data entry away from the file handling and
record keeping.
Now it seems almost trivially easy using the sockets module to communicate
between machines on the same LAN, so that I want to do the record keeping on one
machine.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
