Member Avatar for Stefano Mtangoo

Hello all,
greetings!
I have been playing with DB, seom time ago and want to resume soon where i got stuck. I want to make MySQLdb to get working with wxpython GUI. I got stuck on how to attach the tuple I got from select command to series to the text controls so that user can edit it!

Any help with very simple code/just words is appreciated

Worries: Will MySQLdb project go on or it will slowly die like Boa? Is there any other MySQL wrapper for python? Which is best between MySQL and PostgreSQL?

Thanks

  • 2 Contributors
  • 4 Replies
  • 77 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Stefano Mtangoo
Member Avatar for jlm699

MySQL and PostgreSQL are a matter of taste.

For me, PostgreSQL just happened to be easier to pick up and the Python module to interface with postgres DB was cleaner and better documented... I don't know what the state of either module is these days however.

I doubt that MySQLdb will die like BOA, since BOA is just a means to design interfaces and is very poorly developed/designed, whereas the MySQLdb module is a way to interact with a MySQL database in Python.

Member Avatar for Stefano Mtangoo

I want to switch to PostGreSQL now. What are your suggestion guys?

Member Avatar for jlm699

psycopg is the module I've used in the past with much ease. I can provide example code if necessary.

Member Avatar for Stefano Mtangoo

I have seen Many module psycopg, and pygresql. which one is easier?
Example, yes it will be great!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.