Re: I want to insert beacon scan result in to a database using python and mysql

On 11/10/2016 06:10 PM, Dennis Lee Bieber wrote: > {I could swear I'd included an example of a parameterized query in my > response... I didn't want to go into the details of "SQL injection attack" > as, based on the rest of the OPs post, it would have needed a large > explanation... And the

Re: I want to insert beacon scan result in to a database using python and mysql

On 11/10/2016 11:32 AM, Chris Angelico wrote: > The easiest way is to use a parameterized query: > > cur.execute("insert into beacon VALUES(null, %s)", (beacon,)) > > I don't understand why so many people conflate parameterized with > prepared. "Prepared statements" have a two-step execution. >

Re: I want to insert beacon scan result in to a database using python and mysql

On Fri, Nov 11, 2016 at 2:36 AM, Michael Torrie wrote: > On 11/10/2016 06:15 AM, Dennis Lee Bieber wrote: >> On Wed, 9 Nov 2016 21:05:50 -0800 (PST), sudeeratechn...@gmail.com >> declaimed the following: >> >>> >>> sql = "insert into beacon VALUES(null, '%s')" % \ >>> (beacon)

Re: I want to insert beacon scan result in to a database using python and mysql

On 11/10/2016 06:15 AM, Dennis Lee Bieber wrote: > On Wed, 9 Nov 2016 21:05:50 -0800 (PST), sudeeratechn...@gmail.com > declaimed the following: > >> >> sql = "insert into beacon VALUES(null, '%s')" % \ >> (beacon) >> > DON'T DO THAT... Wouldn't hurt to include a brief why on this, and the

I want to insert beacon scan result in to a database using python and mysql

when this files run gives corresponding output values as; # test BLE Scanning software # jcs 6/8/2014 import MySQLdb as my import blescan import sys import bluetooth._bluetooth as bluez dev_id = 0 db = my.connect(host="localhost", user="root", passwd="root", db="test" ) cursor =

Re: How to connect the MYSQL database to Python program?

58:02 AM UTC-8, Chris Angelico wrote: >> >> On Thu, Dec 10, 2015 at 4:51 AM, ICT Ezy <ict...@gmail.com> wrote: >> >> > Pl explain me how to connect the MYSQL database to Python program? >> >> >> >> You start by looking for a module that lets

Re: How to connect the MYSQL database to Python program?

<ict...@gmail.com> wrote: > >> > Pl explain me how to connect the MYSQL database to Python program? > >> > >> You start by looking for a module that lets you do that. You can use > >> your favourite web search engine, or go directly to PyPI. > >

Re: How to connect the MYSQL database to Python program?

t 1:36 PM, ICT Ezy <ict...@gmail.com> wrote: > >> > On Wednesday, December 9, 2015 at 9:58:02 AM UTC-8, Chris Angelico wrote: > >> >> On Thu, Dec 10, 2015 at 4:51 AM, ICT Ezy <ict...@gmail.com> wrote: > >> >> > Pl explain me how to connect the

Re: How to connect the MYSQL database to Python program?

On Wednesday, December 9, 2015 at 9:58:02 AM UTC-8, Chris Angelico wrote: > On Thu, Dec 10, 2015 at 4:51 AM, ICT Ezy <ict...@gmail.com> wrote: > > Pl explain me how to connect the MYSQL database to Python program? > > You start by looking for a module that lets you do tha

Re: How to connect the MYSQL database to Python program?

On Wednesday, December 9, 2015 at 1:45:26 PM UTC-8, Mark Lawrence wrote: > On 09/12/2015 17:51, ICT Ezy wrote: > > Pl explain me how to connect the MYSQL database to Python program? > > > > Use a search engine. Then run up an editor, write some code, run said > code. I

Re: How to connect the MYSQL database to Python program?

On Friday, December 11, 2015 at 10:36:33 AM UTC-8, ICT Ezy wrote: > On Wednesday, December 9, 2015 at 9:58:02 AM UTC-8, Chris Angelico wrote: > > On Thu, Dec 10, 2015 at 4:51 AM, ICT Ezy <ict...@gmail.com> wrote: > > > Pl explain me how to connect the MYSQL database to Pyth

Re: How to connect the MYSQL database to Python program?

On Wednesday, December 9, 2015 at 1:45:26 PM UTC-8, Mark Lawrence wrote: > On 09/12/2015 17:51, ICT Ezy wrote: > > Pl explain me how to connect the MYSQL database to Python program? > > > > Use a search engine. Then run up an editor, write some code, run said > code. I

Re: How to connect the MYSQL database to Python program?

On Fri, Dec 11, 2015 at 1:36 PM, ICT Ezy <ict...@gmail.com> wrote: > On Wednesday, December 9, 2015 at 9:58:02 AM UTC-8, Chris Angelico wrote: >> On Thu, Dec 10, 2015 at 4:51 AM, ICT Ezy <ict...@gmail.com> wrote: >> > Pl explain me how to connect the MYSQL databas

Re: How to connect the MYSQL database to Python program?

<ict...@gmail.com> wrote: > >> > Pl explain me how to connect the MYSQL database to Python program? > >> > >> You start by looking for a module that lets you do that. You can use > >> your favourite web search engine, or go directly to PyPI. > >

How to connect the MYSQL database to Python program?

Pl explain me how to connect the MYSQL database to Python program? -- https://mail.python.org/mailman/listinfo/python-list

Re: How to connect the MYSQL database to Python program?

On Thu, Dec 10, 2015 at 4:51 AM, ICT Ezy <ict...@gmail.com> wrote: > Pl explain me how to connect the MYSQL database to Python program? You start by looking for a module that lets you do that. You can use your favourite web search engine, or go directly to PyPI. Then you learn h

Re: How to connect the MYSQL database to Python program?

On 09/12/2015 17:51, ICT Ezy wrote: Pl explain me how to connect the MYSQL database to Python program? Use a search engine. Then run up an editor, write some code, run said code. If you then have problems state your OS, Python version and provide us with the full traceback

querying hive database using python

I have server A and Server B. Server B is a hadoop cluster which has hive database and etc.. Server A has python 2.7. I would like to write a hive query using python on Server A to pull data from Server B. Server A and B has connectivity and no issues with network etc.. I have installed all

Re: Connect to VectorWise database usin Python

On Monday, 2 June 2014 09:38:44 UTC+5:30, sukesh.b...@thomsonreuters.com wrote: Hi, Using python(2.7.2) I am not able to connect to Vector Wise database. Can you suggest me how I can connect to it. If you don't mind step by step L. Regards, Sukesh. --

Connect to VectorWise database usin Python

Hi, Using python(2.7.2) I am not able to connect to Vector Wise database. Can you suggest me how I can connect to it. If you don't mind step by step :(. Regards, Sukesh. -- https://mail.python.org/mailman/listinfo/python-list

Re: Access database - GUI - Python - I need architectural advice

Am 28.11.2013 02:32, schrieb Mark Lawrence: On 28/11/2013 01:05, Dennis Lee Bieber wrote: Not quite as friendly, and sort of a moving target: Look at Dabo [the creators' goal was to create a Python equivalent of Visual FoxPro]. At http://www.dabodev.com/ and mailing list at

Re: Access database - GUI - Python - I need architectural advice

I wish to develop a database application with a lot of specific functionnalities dealing with sound files. I have developped an Access prototype and run into a first problem : Access is not a database, it's a data shredder. And for the GUI part; it only works on that pathologic

Re: Access database - GUI - Python - I need architectural advice

Am 28.11.13 07:51, schrieb Ben Finney: Chris Angelico ros...@gmail.com writes: On Thu, Nov 28, 2013 at 4:55 PM, jm.almeras jm.alme...@nospam.net wrote: 2) dimensionable and editable arrays of columns and rows like when you open a table under Access. I'm not aware of a widget in Tkinter

Access database - GUI - Python - I need architectural advice

Hello ! I wish to develop a database application with a lot of specific functionnalities dealing with sound files. I have developped an Access prototype and run into a first problem : it is not so easy to find code working with VBA to extract the duration of a sound file. I have found many

Re: Access database - GUI - Python - I need architectural advice

On Thu, Nov 28, 2013 at 8:35 AM, jm.almeras jm.alme...@nospam.net wrote: Access, and more generally VB, is excellent for building the GUI (forms, widgets etc.). Python is a great for coding, and it comes with high quality libraries... Does anyone have any suggestions as to how I can build my

Re: Access database - GUI - Python - I need architectural advice

On 28/11/2013 01:05, Dennis Lee Bieber wrote: Not quite as friendly, and sort of a moving target: Look at Dabo [the creators' goal was to create a Python equivalent of Visual FoxPro]. At http://www.dabodev.com/ and mailing list at gmane.comp.python.dabo.users. -- Python is the second

Re: Access database - GUI - Python - I need architectural advice

On Thursday, November 28, 2013 3:05:13 AM UTC+5:30, jm.almeras wrote: Hello ! I wish to develop a database application with a lot of specific functionnalities dealing with sound files. I have developped an Access prototype and run into a first problem : it is not so easy to find code

Re: Access database - GUI - Python - I need architectural advice

On Thu, Nov 28, 2013 at 4:55 PM, jm.almeras jm.alme...@nospam.net wrote: Thank you ChrisA These are good ideas. But looking precisely at widgets I will need, is one of the GUI builders capable of offering : 1) the use of tabs in a form (that excludes Tkinter I believe) 2) dimensionable and

Re: Access database - GUI - Python - I need architectural advice

Chris Angelico ros...@gmail.com writes: On Thu, Nov 28, 2013 at 4:55 PM, jm.almeras jm.alme...@nospam.net wrote: These are good ideas. But looking precisely at widgets I will need, is one of the GUI builders capable of offering : The term “GUI builder” to me implies an interactive tool for

Re: Web hosting when you need to install your own modules (was Re: Interact with SQL Database using Python 2.4 or lower)

On 8/28/11 10:52 PM, Chris Angelico wrote: * DNS record changes required a support ticket (this was shared web hosting, so I didn't have control over the BIND files - that's what they said, anyway) Ouch: I never let a webhost near my domain names. I was burned somewhere around that a long time

Re: Interact with SQL Database using Python 2.4 or lower

Personally, I'm a major fan of Webfaction -- from price to plans to what's supported to actual effectiveness of their tech support. +1 Malcolm -- http://mail.python.org/mailman/listinfo/python-list

Interact with SQL Database using Python 2.4 or lower

with a SQL database using python modules from Python 2.4 or earlier? Do you know of a python 2.4 module that will let me interact with an SQL database(can be MySQL, SQLite, etc.)? -- http://mail.python.org/mailman/listinfo/python-list

Re: Interact with SQL Database using Python 2.4 or lower

On 8/28/11 9:49 PM, Sascha wrote: My Problem: the webhost runs Python 2.4 so I cannot communicate with(query or modify) my SQLite3 database. The webhost will not allow me to install my own version of python or upload modules unless I upgrade to VPS. Get a new webhost. Seriously. This is a

Re: Interact with SQL Database using Python 2.4 or lower

On Mon, Aug 29, 2011 at 3:09 PM, Stephen Hansen me+list/pyt...@ixokai.io wrote: Get a new webhost. ... But I don't know if they have a warehouse in Australia, if their latency with any of their various data centers is suitable for you. Maybe, maybe not -- but there /has/ to be a better option

Re: Interact with SQL Database using Python 2.4 or lower

On 8/28/11 10:23 PM, Chris Angelico wrote: On Mon, Aug 29, 2011 at 3:09 PM, Stephen Hansen me+list/pyt...@ixokai.io wrote: Get a new webhost. ... But I don't know if they have a warehouse in Australia, if their latency with any of their various data centers is suitable for you. Maybe, maybe

Web hosting when you need to install your own modules (was Re: Interact with SQL Database using Python 2.4 or lower)

On Mon, Aug 29, 2011 at 3:39 PM, Stephen Hansen me+list/pyt...@ixokai.io wrote: Just don't get too tied to a certain host until you feel them out. Sending them emails with detailed questions before you sign up is a good thing, for example. That helps a lot, but the problems I had with my most

Backup postgresql database from python

Hi, I need to backup a postgresql database from python withour using pg_dump! Is any way of doing that? Thank you in advance for your help. Zorze -- http://mail.python.org/mailman/listinfo/python-list

Re: Backup postgresql database from python

On Sat, 4 Dec 2010 19:12:08 + starglider develop starglider@gmail.com wrote: I need to backup a postgresql database from python withour using pg_dump! Is any way of doing that? Probably. I guess the first question is why can't you use pg_dump? That might give us a clue

Re: Backup postgresql database from python

On Dec 4, 2010, at 2:32 PM, D'Arcy J.M. Cain wrote: On Sat, 4 Dec 2010 19:12:08 + starglider develop starglider@gmail.com wrote: I need to backup a postgresql database from python withour using pg_dump! Is any way of doing that? Probably. I guess the first question is why can't

Distributed database in Python

Greetings. I'm looking for a distributed database. (I'm not sure if distributed is the correct terminology though). My problem is this; I have a client application which once in a while needs to sync with a central database. (And of course the client -databases might be updated locally etc). Are

Re: Distributed database in Python

http://www.google.com/search?q=python+distributed+database If you have already tried this, then you should say so, so that we don't waste our time, and yours, going over ground you have already covered. -- Steven -- http://mail.python.org/mailman/listinfo/python-list

Possible to access MS Access 2007 password-protected database from Python?

Googling has shown me various ways of connecting to a non-password- protected Access database, but I was wondering if someone could point to code illustrating how to use an Access db that's password- protected. I haven't been able to find anything on this. Thanks, Ken --

Re: How to display Chinese in a list retrieved from database via python

zxo102 zxo...@gmail.com wrote in message news:2560a6e0-c103-46d2-aa5a-8604de4d1...@b38g2000prf.googlegroups.com... I have a list in a dictionary and want to insert it into the html file. I test it with following scripts of CASE 1, CASE 2 and CASE 3. I can see 中文 in CASE 1 but that is not

Re: How to display Chinese in a list retrieved from database via python

On 12月29日, 下午5时06分, Mark Tolonen metolone+gm...@gmail.com wrote: zxo102 zxo...@gmail.com wrote in message news:2560a6e0-c103-46d2-aa5a-8604de4d1...@b38g2000prf.googlegroups.com... I have a list in a dictionary and want to insert it into the html file. I test it with following scripts of

Re: How to display Chinese in a list retrieved from database via python

zxo102 zxo...@gmail.com wrote in message news:7e38e76a-d5ee-41d9-9ed5-73a2e2993...@w1g2000prm.googlegroups.com... On 12月29日, 下午5时06分, Mark Tolonen metolone+gm...@gmail.com wrote: zxo102 zxo...@gmail.com wrote in message

Re: How to display Chinese in a list retrieved from database via python

On 12月27日, 下午4时08分, Gabriel Genellina gagsl-...@yahoo.com.ar wrote: En Sat, 27 Dec 2008 03:03:24 -0200,zxo102zxo...@gmail.com escribió: On 12月26日, 下午3时16分, Mark Tolonen metolone+gm...@gmail.com   wrote: I was able to display 中文 successfully with this code: f=open('test.html','wt')

Re: How to display Chinese in a list retrieved from database via python

En Sat, 27 Dec 2008 03:03:24 -0200, zxo102 zxo...@gmail.com escribió: On 12月26日, 下午3时16分, Mark Tolonen metolone+gm...@gmail.com wrote: I was able to display 中文 successfully with this code: f=open('test.html','wt') f.write('''htmlhead META HTTP-EQUIV=Content-Type

Re: How to display Chinese in a list retrieved from database via python

On 12月26日, 下午3时16分, Mark Tolonen metolone+gm...@gmail.com wrote: zxo102 zxo...@gmail.com wrote in message news:979fdf6d-0500-47ba-87fd-0f0361ca3...@p2g2000prf.googlegroups.com... On 12月26日, 上午4时58分, Gabriel Genellina gagsl-...@yahoo.com.ar wrote: En Thu, 25 Dec 2008 07:27:03 -0200,

Re: How to display Chinese in a list retrieved from database via python

On 12月25日, 下午3时35分, Chris Rebert c...@rebertia.com wrote: On Wed, Dec 24, 2008 at 11:29 PM, zxo102 zxo...@gmail.com wrote: Hi, I retrieve some info in Chinese from postgresql and assign it to a variable 'info' defined in javascript of a html page: var info =

Re: How to display Chinese in a list retrieved from database via python

-On [20081225 08:30], zxo102 (zxo...@gmail.com) wrote: Anybody knows how to solve this problem? You are assigning/pushing out Python byte sequences, not Unicode. Look at u'' string variables, x.encode() and x.decode() to help you. It's widely documented on the Internet, a quick Python Unicode

Re: How to display Chinese in a list retrieved from database via python

En Thu, 25 Dec 2008 07:27:03 -0200, zxo102 zxo...@gmail.com escribió: On 12月25日, 下午3时35分, Chris Rebert c...@rebertia.com wrote: On Wed, Dec 24, 2008 at 11:29 PM, zxo102 zxo...@gmail.com wrote: Hi, I retrieve some info in Chinese from postgresql and assign it to a variable 'info' defined

Re: How to display Chinese in a list retrieved from database via python

On 12月26日, 上午4时58分, Gabriel Genellina gagsl-...@yahoo.com.ar wrote: En Thu, 25 Dec 2008 07:27:03 -0200, zxo102 zxo...@gmail.com escribió: On 12月25日, 下午3时35分, Chris Rebert c...@rebertia.com wrote: On Wed, Dec 24, 2008 at 11:29 PM, zxo102 zxo...@gmail.com wrote: Hi, I retrieve some

Re: How to display Chinese in a list retrieved from database via python

zxo102 zxo...@gmail.com wrote in message news:979fdf6d-0500-47ba-87fd-0f0361ca3...@p2g2000prf.googlegroups.com... On 12月26日, 上午4时58分, Gabriel Genellina gagsl-...@yahoo.com.ar wrote: En Thu, 25 Dec 2008 07:27:03 -0200, zxo102 zxo...@gmail.com escribió: On 12月25日, 下午3时35分, Chris Rebert

How to display Chinese in a list retrieved from database via python

Hi, I retrieve some info in Chinese from postgresql and assign it to a variable 'info' defined in javascript of a html page: var info = ['\xd6\xd0\xce\xc4','\xd6\xd0\xce\xc4','\xd6\xd0\xce \xc4'] But I want it to be var info = ['中文','中文','中文'] since in html pages (via javascript), the

Re: How to display Chinese in a list retrieved from database via python

On Wed, Dec 24, 2008 at 11:29 PM, zxo102 zxo...@gmail.com wrote: Hi, I retrieve some info in Chinese from postgresql and assign it to a variable 'info' defined in javascript of a html page: var info = ['\xd6\xd0\xce\xc4','\xd6\xd0\xce\xc4','\xd6\xd0\xce \xc4'] But I want it to be

Re: Copy database with python..

Abandoned a écrit : Hi. I want to copy my database but python give me error when i use this command. cursor.execute(pg_dump mydata old.dump) What is the problem ? Could it have to do with the fact that cursor.execute expects a valid SQL query - not a bash command line ? And how can i

Re: Copy database with python..

On Nov 2, 2007, at 11:49 AM, Diez B. Roggisch wrote: Abandoned wrote: On Nov 2, 4:19 pm, Paul McNett [EMAIL PROTECTED] wrote: Abandoned wrote: Hi. I want to copy my database but python give me error when i use this command. cursor.execute(pg_dump mydata old.dump) What is the problem

Re: Copy database with python..

Abandoned == Abandoned [EMAIL PROTECTED] writes: Abandoned Yes i understand thank you. Now i find that maybe help the Abandoned other users. Abandoned import os Abandoned os.system(su postgres) Abandoned ... I get the distinct impression that you're trying to replace simple shell scripting

Re: Copy database with python..

On Nov 2, 4:19 pm, Paul McNett [EMAIL PROTECTED] wrote: Abandoned wrote: Hi. I want to copy my database but python give me error when i use this command. cursor.execute(pg_dump mydata old.dump) What is the problem ? And how can i copy the database with python ? You are just going

Re: Copy database with python..

On Nov 2, 4:11 pm, Martin Sand Christensen [EMAIL PROTECTED] wrote: Abandoned == Abandoned [EMAIL PROTECTED] writes: Abandoned I want to copy my database but python give me error when i Abandoned use this command. cursor.execute(pg_dump mydata old.dump) Abandoned What is the problem

Re: Copy database with python..

Abandoned wrote: Hi. I want to copy my database but python give me error when i use this command. cursor.execute(pg_dump mydata old.dump) What is the problem ? And how can i copy the database with python ? You are just going to have to give us more to go on. Please post the entire

Re: Copy database with python..

Abandoned == Abandoned [EMAIL PROTECTED] writes: Abandoned I want to copy my database but python give me error when i Abandoned use this command. cursor.execute(pg_dump mydata old.dump) Abandoned What is the problem ? cursor.execute() is for executing SQL commands, and this is not an SQL

Re: Copy database with python..

On Fri, 2007-11-02 at 06:51 -0700, Abandoned wrote: Hi. I want to copy my database but python give me error when i use this command. cursor.execute(pg_dump mydata old.dump) cursor.execute executes SQL queries. pg_dump is not an SQL query, it is an operating system command. To execute OS

Copy database with python..

Hi. I want to copy my database but python give me error when i use this command. cursor.execute(pg_dump mydata old.dump) What is the problem ? And how can i copy the database with python ? Note: The database's size is 200 GB -- http://mail.python.org/mailman/listinfo/python-list

Re: Copy database with python..

Abandoned wrote: On Nov 2, 4:19 pm, Paul McNett [EMAIL PROTECTED] wrote: Abandoned wrote: Hi. I want to copy my database but python give me error when i use this command. cursor.execute(pg_dump mydata old.dump) What is the problem ? And how can i copy the database with python ? You

Re: EyeDB Object Database (ODBMS) - Python wrapper

GinTon wrote: EyeDB is a free ODBMS based on the ODMG 3 specification with programming interfaces for C++ and Java. It is very powerfull, mature, safe and stable. In fact, it was developed in 1992 for the Genome View project althought rewritten in 1994, and has been used in a lot of

Re: EyeDB Object Database (ODBMS) - Python wrapper

I received the following answer of Eric Viara, EyeDB.org: We planned to introduce soon a plugin mechanism to facilitate the way to write language bindings such as PHP5, Python, PERL and so on. But we do not know yet if the Python binding will be written by the core staff. We do not plan to

EyeDB Object Database (ODBMS) - Python wrapper

EyeDB is a free ODBMS based on the ODMG 3 specification with programming interfaces for C++ and Java. It is very powerfull, mature, safe and stable. In fact, it was developed in 1992 for the Genome View project althought rewritten in 1994, and has been used in a lot of bioinformatics projects

How do I open a mysql database with python

How do I open a mysql database with python. I nead a module that is compatible with windows, and will be on any regular server I singup with. if you could give me some documentation on the module that would be good also. Thanks -- http://mail.python.org/mailman/listinfo/python-list

Re: How do I open a mysql database with python

http://sourceforge.net/projects/mysql-python -- http://mail.python.org/mailman/listinfo/python-list

Re: How do I open a mysql database with python

Or mxODBC http://www.egenix.com/files/python/mxODBC.html rpd -- http://mail.python.org/mailman/listinfo/python-list

Re: Access Database Using Python

Karthish [EMAIL PROTECTED] (K) wrote: K I can't figure out how to authenticate and then load a page, since the K page requires cookies for authentication. http://www.voidspace.org.uk/python/articles/cookielib.shtml http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/302930 -- Piet van

Access Database Using Python

I'm writing a script to look through DNA sequences in a database and select sequences I require. So far, my code looks like this for authentication: import os import Bio.Clustalw from Bio.Alphabet import IUPAC import pdb import sys import os import urllib import urllib2 import urllib userid =

Access Database Using Python

I'm writing a script to look through DNA sequences in a database and select sequences I require. So far, my code looks like this for authentication: import os import Bio.Clustalw from Bio.Alphabet import IUPAC import pdb import sys import os import urllib import urllib2 import urllib userid =

Re: database in python ?

Steve Holden wrote: I don't know about the whole picture, but I know form evidence on this group that there are PostgreSQL driver modules (the name psycopg comes to mind, but this may be false memory) that appear to take diabolical liberties with DBAPI-2.0, whereas my experience with MySQLdb

Re: database in python ?

Mage wrote: Andy Dustman wrote: Transactions available since 3.23.17 (June 2000) Transactions only supported on slow database types like innodb. If you ever tried it you cannot say that mysql supports transactions. No. Last time when I tried mysql 4.x did explicit commit if you simply

Re: database in python ?

On Tuesday 12 April 2005 04:54 pm, Pierre-Frédéric Caillaud wrote: Speaking of the manual, the mysql manual is quite... well... i don't quite find the word, but it has many sentences which sound like PR stuff. Like, we don't do this like you or anyone would expect, but there is a

Re: database in python ?

Terry Hancock wrote: [...] That's interesting. Most sources I've read seemed to suggest that postgresql is slower than MySQL, at least for modest size tables. There must, I suppose, be some turnover point on the size of the database? Or are you arguing that postgresql is now faster than MySQL

Re: database in python ?

postgresql is slower than MySQL, at least for modest size tables. There must, I When not using transactions, MySQL will blow away postgres in INSERT/UPDATE speed until the concurrency gets up a bit and the readers block writers strategy used by MyISAM starts to show its weaknesses. This is

Re: database in python ?

Andy Dustman wrote: Transactions available since 3.23.17 (June 2000) Transactions only supported on slow database types like innodb. If you ever tried it you cannot say that mysql supports transactions. No. Last time when I tried mysql 4.x did explicit commit if you simply disconnected

Re: database in python ?

Pierre-Frédéric Caillaud wrote: MySQL is an excellent option is very well documented. It is also a defacto standard for OpenSource databases. MySQL sucks for anything but very very basic stuff as it supports no transactions, foreign keys, procedures, triggers, concurrency, etc.

Re: database in python ?

In truth, although postgres has more features, MySQL is probably better for someone who is just starting to use databases to develop for: the chances are higher that anyone using their code will have MySQL than Postgres, and they aren't going to need the features that Postgresql has that

Re: database in python ?

Bottomline - mysql has a lot of marketshare, is improving, and I'm sure that it'll eventually be a credible product. But right now it's has a wide range of inexcusable problems. I so totally agree with you. I find that mysql promotes bad coding practices by ignoring errors and substituting

Re: database in python ?

Buck Nuggets wrote: 1. mysql doesn't support transactions - one of its io layers (innodb) does. If you're hoping to get your application hosted you will find that most mysql installations don't support innodb. And due to the bugs in mysql, when you attempt to create a transaction-safe

Re: database in python ?

It's not a bug if you didn't RTFM. Maybe it's not a bug if it's the only DBMS you've ever used and you actually believe that overriding explicit critical declaratives is a valid design choice. But it is a bug if it's still only partially supported in a beta version that nobody is yet hosting.

Re: database in python ?

It's not a bug if you didn't RTFM. I did read it in much detail ! In fact I spent a lot of time trying to make understand how it could do a simple 4-table join to display also purchased products on an online store. The damn query took 0.5 seconds to execute no matter how I twisted it in

Re: database in python ?

MySQL is an excellent option is very well documented. It is also a defacto standard for OpenSource databases. You will need to install the Python module MySQLdb. -- http://sourceforge.net/projects/mysql-python There should be plenty of examples online too for using MySQLdb with Python. If you

Re: database in python ?

MySQL is an excellent option is very well documented. It is also a defacto standard for OpenSource databases. MySQL sucks for anything but very very basic stuff as it supports no transactions, foreign keys, procedures, triggers, concurrency, etc. Postgresql is a lot better, free, and the

Re: database in python ?

Pierre-Frédéric Caillaud wrote: MySQL is an excellent option is very well documented. It is also a defacto standard for OpenSource databases. MySQL sucks for anything but very very basic stuff as it supports no transactions, foreign keys, procedures, triggers, concurrency, etc.

Re: database in python ?

[EMAIL PROTECTED] wrote: I need to build table which need searching data which needs more power then dictionary or list in python, can anyone help me what kind of database suitable for python light and easy to learn. Is mySQL a nice start with python ? It depends... mySQL is fine for more

Re: database in python ?

In article [EMAIL PROTECTED], [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello I need to build table which need searching data which needs more power then dictionary or list in python, can anyone help me what kind of database suitable for python light and easy to learn. Is mySQL a nice start

Re: database in python ?

[EMAIL PROTECTED] [EMAIL PROTECTED] said : Hello I need to build table which need searching data which needs more power then dictionary or list in python, can anyone help me what kind of database suitable for python light and easy to learn. Is mySQL a nice start with python

Re: database in python ?

If you want Simple you can use the following piece of code. It won't work if you have a million records, but it's a nice intelligent flatfile storage with a select where + order by and limit emulator. # # class ListMgr( object ):

Re: database in python ?

On Monday 11 April 2005 11:01, Pierre-Frédéric Caillaud wrote: psycopg ... has a dictfetchall() method which is worth its weight in donuts ! It's very simple to write one for MySQLdb: def dictfetchall(cursor): '''Takes a MySQLdb cursor and returns the rows as dictionaries.'''

Re: database in python ?

Pierre-Frédéric Caillaud wrote: MySQL is an excellent option is very well documented. It is also a defacto standard for OpenSource databases. MySQL sucks for anything but very very basic stuff as it supports no transactions, Transactions available since 3.23.17 (June 2000)

Re: database in python ?

Ola Natvig wrote: MySQL has support for transactions and foreign keys in it's InnoDB engine. In 5.0 it supports views procedures. Some people seems to hate MySQL :-) but a whole lot of other people like it a lot. There are other problems, such as failing silently in many circumstances, as

Re: database in python ?

Pierre-Frédéric Caillaud wrote: MySQL is an excellent option is very well documented. It is also a defacto standard for OpenSource databases. MySQL sucks for anything but very very basic stuff as it supports no transactions, foreign keys, procedures, triggers, concurrency, etc.

database in python ?

Hello I need to build table which need searching data which needs more power then dictionary or list in python, can anyone help me what kind of database suitable for python light and easy to learn. Is mySQL a nice start with python ? Sincerely Yours, Pujo -- http://mail.python.org/mailman

Re: database in python ?

[EMAIL PROTECTED] wrote: I need to build table which need searching data which needs more power then dictionary or list in python, can anyone help me what kind of database suitable for python light and easy to learn. Is mySQL a nice start with python ? You could try SQLite for Python: http