Re: python and databases

2017-03-15 Thread Michael Torrie
On 03/15/2017 08:45 AM, Xristos Xristoou wrote: > first thx for response second i cant use additional packate because i > build tool for other python program and that use standar python > only, I don't see how you can retrieve data from MS Access without a tool that is not part of the standard Pyt

Re: python and databases

2017-03-15 Thread Xristos Xristoou
Τη Τρίτη, 14 Μαρτίου 2017 - 9:59:42 μ.μ. UTC+2, ο χρήστης Xristos Xristoou έγραψε: first thx for response second i cant use additional packate because i build tool for other python program and that use standar python only, sqlite is in standar python 2.7 @Irmen de Jong ? can use quyries in CSV @

Re: python and databases

2017-03-15 Thread Sibylle Koczian
Am 15.03.2017 um 01:23 schrieb Michael Torrie: On 03/14/2017 01:59 PM, Xristos Xristoou wrote: I have a database in microsoft ACCESS with about 150 records.. if I want to get some data from this database using a query in python and i want to store in some variables in python that will do this

Re: python and databases

2017-03-14 Thread Michael Torrie
On 03/14/2017 01:59 PM, Xristos Xristoou wrote: > I have a database in microsoft ACCESS with about 150 records.. if I > want to get some data from this database using a query in python and > i want to store in some variables in python that will do this ? to > avoid the 150 if ...: Using the stand

Re: python and databases

2017-03-14 Thread Irmen de Jong
On 14-3-2017 20:59, Xristos Xristoou wrote: > I have a database in microsoft ACCESS with about 150 records.. if I want to > get some > data from this database using a query in python and i want to store in some > variables in python that will do this ? to avoid the 150 if ...: Using the > stand

Re: python and databases

2017-03-14 Thread BrJohan
On 2017-03-14 20:59, Xristos Xristoou wrote: I have a database in microsoft ACCESS with about 150 records.. if I want to get some data from this database using a query in python and i want to store in some variables in python that will do this ? to avoid the 150 if ...: Using the standard li

Re: python and databases

2017-03-14 Thread Chris Angelico
On Wed, Mar 15, 2017 at 6:59 AM, Xristos Xristoou wrote: > I have a database in microsoft ACCESS with about 150 records.. if I want to > get some data from this database using a query in python and i want to store > in some variables in python that will do this ? to avoid the 150 if ...: > Us

Re: python and databases

2017-03-14 Thread Irving Duran
I don't know that there is a native library in python for you to call an MS Access db. Would you be able to extract the content into a CSV and read it that way? Also, is there a particular reason why you couldn't use an additional python lib? Thank You, Irving Duran On Tue, Mar 14, 2017 at 2:5

python and databases

2017-03-14 Thread Xristos Xristoou
I have a database in microsoft ACCESS with about 150 records.. if I want to get some data from this database using a query in python and i want to store in some variables in python that will do this ? to avoid the 150 if ...: Using the standard library the python? know easily put it an SQL que

Re: Free chapter about Python and databases (MySQL and SQLite)

2010-05-31 Thread christian schulze
On 28 Mai, 18:09, Peter Otten <__pete...@web.de> wrote: > christian schulze wrote: > > On 28 Mai, 17:12, Sebastian Bassi wrote: > >> On Fri, May 28, 2010 at 9:41 AM, Tino Wildenhain > >> wrote: > >> > Did you consider adding a part dealing with postgresql too? > >> > (Especially interesting in th

Re: Free chapter about Python and databases (MySQL and SQLite)

2010-05-29 Thread John Bokma
Robinow writes: > > On May 28, 2010, at 10:05 PM, John Bokma wrote: > >> Sebastian Bassi writes: >> >>> On Fri, May 28, 2010 at 12:37 AM, John Bokma >>> wrote: >> >> Even if it's just a few bucks, it's still money saved [0]. On top of >> that I think it's way better to point your audience to

Re: Free chapter about Python and databases (MySQL and SQLite)

2010-05-28 Thread Robinow
wrote: Sebastian Bassi writes: On Fri, May 28, 2010 at 12:37 AM, John Bokma wrote: Even if it's just a few bucks, it's still money saved [0]. On top of that I think it's way better to point your audience to good books on the topic and skip the intro instead of doing a (half hearted

Re: Free chapter about Python and databases (MySQL and SQLite)

2010-05-28 Thread John Bokma
Sebastian Bassi writes: > On Fri, May 28, 2010 at 12:37 AM, John Bokma wrote: >> I feel more than uncomfortable with example code that uses: user="root" > > What's wrong with this? It is just an example of connection string. > The reader will use his/her user/pass/dbname according to their own >

Re: Free chapter about Python and databases (MySQL and SQLite)

2010-05-28 Thread Peter Otten
christian schulze wrote: > On 28 Mai, 17:12, Sebastian Bassi wrote: >> On Fri, May 28, 2010 at 9:41 AM, Tino Wildenhain >> wrote: >> > Did you consider adding a part dealing with postgresql too? >> > (Especially interesting in the way you can write stored functions >> > in python there) >> >> Th

Re: Free chapter about Python and databases (MySQL and SQLite)

2010-05-28 Thread christian schulze
On 28 Mai, 17:12, Sebastian Bassi wrote: > On Fri, May 28, 2010 at 9:41 AM, Tino Wildenhain wrote: > > Did you consider adding a part dealing with postgresql too? > > (Especially interesting in the way you can write stored functions > > in python there) > > That is a good idea for the next versio

Re: Free chapter about Python and databases (MySQL and SQLite)

2010-05-28 Thread Sebastian Bassi
On Fri, May 28, 2010 at 9:41 AM, Tino Wildenhain wrote: > Did you consider adding a part dealing with postgresql too? > (Especially interesting in the way you can write stored functions > in python there) That is a good idea for the next version/edition. But meanwhile I could write something in m

Re: Free chapter about Python and databases (MySQL and SQLite)

2010-05-28 Thread Tino Wildenhain
Hi, Am 28.05.2010 04:45, schrieb Sebastian Bassi: Hello, I want to announce that the publisher of "Python for Bioinformatis" (CRC Press) allowed me to publish a chapter from my book. I decided to publish the chapter about "Python and databases". I think it may be usef

Re: Free chapter about Python and databases (MySQL and SQLite)

2010-05-27 Thread Sebastian Bassi
On Fri, May 28, 2010 at 12:37 AM, John Bokma wrote: > I feel more than uncomfortable with example code that uses: user="root" What's wrong with this? It is just an example of connection string. The reader will use his/her user/pass/dbname according to their own settings. > (e.g. p291). I never g

Re: Free chapter about Python and databases (MySQL and SQLite)

2010-05-27 Thread John Bokma
Sebastian Bassi writes: > Hello, I want to announce that the publisher of "Python for > Bioinformatis" (CRC Press) allowed me to publish a chapter from my > book. > I decided to publish the chapter about "Python and databases". I think > it may be useful for so

Free chapter about Python and databases (MySQL and SQLite)

2010-05-27 Thread Sebastian Bassi
Hello, I want to announce that the publisher of "Python for Bioinformatis" (CRC Press) allowed me to publish a chapter from my book. I decided to publish the chapter about "Python and databases". I think it may be useful for somebody. The official announcement and downloa

Python and databases (was: Re: how you get Python files on websites?)

2006-06-15 Thread Ben Finney
[EMAIL PROTECTED] writes: > 1. Can Python work with databases like MySql,Oracle? (i think it > sounds silly) Not silly: http://www.python.org/topics/database/> -- \ "Money is always to be found when men are to be sent to the | `\ frontiers to be destroyed: when the object is t