Re: [Tutor] How to write database-agnostic python code? (Is this even possible?)

2017-09-13 Thread Cameron Simpson
On 12Sep2017 14:05, boB Stepp wrote: As I continue to read about SQL, one thing jumps out: There are many differences between how SQL statements are implemented among the different database products. Even for relatively simple, straightforward things like field concatenation. One DB might use

Re: [Tutor] How to write database-agnostic python code? (Is this even possible?)

2017-09-13 Thread boB Stepp
I forgot one other thing you mentioned that I had a question about. On Wed, Sep 13, 2017 at 2:41 AM, Alan Gauld via Tutor wrote: > If you limit your SQL to queries fetching raw fields you > should find you are working with the portable subset of > standard SQL most of the time. Basically you are

Re: [Tutor] How to write database-agnostic python code? (Is this even possible?)

2017-09-13 Thread boB Stepp
On Wed, Sep 13, 2017 at 2:55 AM, Peter Otten <__pete...@web.de> wrote: > boB Stepp wrote: >> >> And these would be the SQL commands/statements I would have >> cursor.execute use from the sqlite3 module. They would be different >> depending on which database product I was using. Am I horribly >>

Re: [Tutor] How to write database-agnostic python code? (Is this even possible?)

2017-09-13 Thread boB Stepp
On Wed, Sep 13, 2017 at 2:41 AM, Alan Gauld via Tutor wrote: > The classic approach is to have 3 tiers in the architecture. > 1) UI layer - usually a GUI toolkit - the VC part of MVC > 2) Business logic - its the M bit of MVC... and where most OOP happens > 3) data access - the ugly underbelly wh

Re: [Tutor] How to write database-agnostic python code? (Is this even possible?)

2017-09-13 Thread Maxime S
2017-09-13 3:58 GMT+02:00 boB Stepp : > On Tue, Sep 12, 2017 at 2:17 PM, Mats Wichmann wrote: > > On 09/12/2017 01:05 PM, boB Stepp wrote: > >> As I continue to read about SQL, one thing jumps out: There are many > >> differences between how SQL statements are implemented among the > >> differen

Re: [Tutor] Create CDF using Python

2017-09-13 Thread Alan Gauld via Tutor
On 13/09/17 01:28, Pareshkumar Panchal wrote: > I have set of data in excel file. i would like to create the CDF plots & > find 40th & 70th Percentile using python with functionality of refresh > whenever the data sets update. There may be a good reason for this but frankly that's what spreadshee

Re: [Tutor] How is database creation normally handled?

2017-09-13 Thread Alan Gauld via Tutor
On 10/09/17 18:41, Mats Wichmann wrote: > restore" and a local copy of the (mysql) db will be built. So that's > what I just agreed with: the setup process happens outside the code app ... > maybe it's not that unusual - any time you need to start with a > reproducible known state of the DB, that

Re: [Tutor] I can not display the answer of the Limit when I click the Button Answer.

2017-09-13 Thread Mats Wichmann
On 09/13/2017 09:03 AM, edmundo pierre via Tutor wrote: >                                                            That is my code > below. I used tkinter to calculate the limit of a function. I used Grid > geometry, but when I click the button Answer, but nothing comes out so I do > not know

[Tutor] I can not display the answer of the Limit when I click the Button Answer.

2017-09-13 Thread edmundo pierre via Tutor
                                                           That is my code below. I used tkinter to calculate the limit of a function. I used Grid geometry, but when I click the button Answer, but nothing comes out so I do not know where I am doing wrong. I hope my code will be visible, I have t

[Tutor] Create CDF using Python

2017-09-13 Thread Pareshkumar Panchal
I am a python beginner, I have set of data in excel file. i would like to create the CDF plots & find 40th & 70th Percentile using python with functionality of refresh whenever the data sets update. Thanks in Advance for your help ! ___ Tutor maillist

Re: [Tutor] How to write database-agnostic python code? (Is this even possible?)

2017-09-13 Thread Peter Otten
boB Stepp wrote: > On Tue, Sep 12, 2017 at 2:17 PM, Mats Wichmann wrote: >> On 09/12/2017 01:05 PM, boB Stepp wrote: >>> As I continue to read about SQL, one thing jumps out: There are many >>> differences between how SQL statements are implemented among the >>> different database products. Eve

Re: [Tutor] How to write database-agnostic python code? (Is this even possible?)

2017-09-13 Thread Alan Gauld via Tutor
On 12/09/17 20:05, boB Stepp wrote: As I continue to read about SQL, one thing jumps out: There are many differences between how SQL statements are implemented usage of SQL. So how does one write one's python program to be DB-agnostic? And if this is impossible, then what is the best way t