Re: [Tutor] Open Source database software
Kent Johnson wrote: On Mon, Nov 24, 2008 at 7:19 PM, Mike Meisner mi...@blazenetme.net wrote: 3. A good GUI front end for creating the database, creating forms for user data input, queries, reports, etc. For this you might look at Dabo: http://dabodev.com/ I haven't worked with it myself but some people like it a lot. PostgreSQL has pgAdmin which is very nice for basic admin but not for user applications. This would also be my best advice. The framework is very solid (core as been stable for a few years know). Documentation exists, although it is lacking and scatered the mailing list is low traffic and very responsive. I would not focus on using the visual tools, although a lot can already be accomplished with them (if you dig or ask you will find info on hand coding forms). It is based on wxPython, and you can drop to that level any time. But in general you rather use the dabo interface as it will provide you with a much cleaner and productive implementation (quite marvelous), and with very good databinding. Database access is abstracted so you can develop for/with SQLite and then just change the backend to one of a few flavours of choice (such as PostgreSQL, Firebird and other commercial options as well). In a nutshelll :-) Miguel VIVA os SEUS SONHOS com o Crédito Pessoal Capital Mais. Peça aqui até 15.000 Euros: http://www.iol.pt/correio/rodape.php?dst=0901052 ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] Open Source database software
Mike Meisner [EMAIL PROTECTED] wrote I'd like to get away from using Microsoft Access. I have a number of Access databases to convert. The obvious choice would be the OpenOffice DB. I believe it can read Access format - although I've never tried... 1. A relational database management system for a single user (i.e, I don't need client/server and all the extra baggage A server based RDBMS is not a lot of extra baggage, especially small ones like Firebird but if you really don't want a server solution then SQLite which comes with Python is file based and good enough for anything but enormous databases. 3. A good GUI front end for creating the database, creating forms for user data input, queries, reports, etc. With opensource the GUI tends to be an add on so you get a separate choice over which front end you want. Personally I don't ever use them so can make no comment, I prefer SQL. Smart enough to easily read and convert an Access (.mdb) database file. THat is likely to be another tool too. Apart from OpenOffice I don't think the databases typically feature conversion tools. everything either in Python or with APIs that Python can easily use. Again SQLite is the obvious choice here but most databases can be accessed from Python via the standard DBAPI and a suitable driver.. HTH, -- Alan Gauld Author of the Learn to Program web site http://www.freenetpages.co.uk/hp/alan.gauld ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] Open Source database software
On Mon, Nov 24, 2008 at 7:19 PM, Mike Meisner [EMAIL PROTECTED] wrote: 3. A good GUI front end for creating the database, creating forms for user data input, queries, reports, etc. For this you might look at Dabo: http://dabodev.com/ I haven't worked with it myself but some people like it a lot. PostgreSQL has pgAdmin which is very nice for basic admin but not for user applications. Kent ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] Open Source database software
On Mon, Nov 24, 2008 at 4:19 PM, Mike Meisner [EMAIL PROTECTED] wrote: I'd like to get away from using Microsoft Access. I have a number of Access databases to convert. There's an open source package out there called mdbtools, specifically for working with Access databases. The Python port (or wrapper? I don't really know) of it can be found here: http://www.parit.ca/software/pscproject.2008-04-21.9636009485 I've never used it, so don't know whether it would be a stable long-term way to work with MDB files, or whether it would be best to write a one-time conversion to a different format... -- www.fsrtechnologies.com ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
[Tutor] Open Source database software
Y'all have been so good with suggestions on my programming problems in the past, I wonder if anyone could provide a suggestion on a more general topic. I'd like to get away from using Microsoft Access. I have a number of Access databases to convert. My needs are: 1. A relational database management system for a single user (i.e, I don't need client/server and all the extra baggage that goes with it). The RDMS must be able to handle graphics objects. 2. Open source with a decent track record. 3. A good GUI front end for creating the database, creating forms for user data input, queries, reports, etc. 4. Smart enough to easily read and convert an Access (.mdb) database file. 5. And, everything either in Python or with APIs that Python can easily use. Has anyone used products that would meet my needs? Thanks. Mike ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] Open Source database software
On Mon, Nov 24, 2008 at 6:19 PM, Mike Meisner [EMAIL PROTECTED] wrote: Y'all have been so good with suggestions on my programming problems in the past, I wonder if anyone could provide a suggestion on a more general topic. snip5. And, everything either in Python or with APIs that Python can easily use. Has anyone used products that would meet my needs? I haven't used anything, but you can connect to mysql databases with python, from what I've read it seems to have all the bells whistles (and then go ahead and add the ability to do whatever you want/can do with python). I'm sure there are plenty of folks with more experience, but that's something to get you started! HTH, Wayne ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor