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

 Hi Jim --

This isn't very urgent, so when you'll have some free time, yes, please ask your friend how big are differences between SQLLite3 and PostgreSQL as well as are there any free tools to generate PostgreSQL SQL scripts to create database tables and relationships etc. from an Entity-Relationship model. I have used here RISEEditor ( http://www.risetobloome.com/Page_1_S.aspx?item=1853 ) - it's free and rather good to draw E-R model but it generates some "garbage" PL/SQL, which have to be heavily edited to get what I wanted to get as that generated PL/SQL does uses some naming conventions, which are far from what I'm accustomed to use here etc.

All-in-all this E-R modeling tool isn't needed that much here - so if there will be no one available then to create database I can just use pgAdmin III or phpPgAdmin, which I have got already successfully installed on my test Win8 VM together with PostgreSQL 9.2.

Thank you.

-- Shamil 


Воскресенье, 14 апреля 2013, 7:16 -07:00 от "Jim Lawrence" <accessd at shaw.ca>:
>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