[dba-Tech] Differences between SQLLite and PostgreSQL SQL syntax, and using ADOdb for Python for a sample project...

Hi Shamil:

At this moment this is beyond me...still a few tutorials away from novice to
guru. ;-)  The only individual here, on this list, that I am aware of, that
has had first hand experience, would be Hans but he is terribly busy.

I will be Skype-ing to a friend today and he has first hand experience with
using SQLLite (PostgreSQL as well I believe) as one of his client's projects
was to have him burn a fully operating SQL version on a ROM/RAM chip for
some kind of oil line controller. 

I could have him give you a call on Skype or Jitsi? 

Jim

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov
Shamil
Sent: Sunday, April 14, 2013 2:35 AM
To: Discussion of Hardware and Softw
Subject: [dba-Tech] Differences between SQLLite and PostgreSQL SQL syntax,
and using ADOdb for Python for a sample project...

 Hi All --

I'd like to learn some Python + SQL programming for a small sample
PostgreSQL project I have mentioned here in another thread. As far as I see
it's almost "no-brainer" effort to start using SQLLite with Python with in
memory - sqllite3.connect(':memory:') - database. So my question is do you
know how big are differences between SQLLite3 and PostgreSQL dialects
including SQL DDL? Also it looks like using ADOdb for Python for this sample
project promise to be helpful - do you know any good links on ADODb for
Python with SQLLite and PostgreSQL tutorials?

Thank you.

-- Shamil

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com