Python vs. Access VBA

[Chris Lambacher]

If you are going to go with Python, don't include Access in the mix at all.
If you want a small light-weight, serverless database back-end, you would be
better to go with SQLite.  Its cross platform and well proven.  I think
Firebird will give you that too, though I have never used it.  

Most people who use Oracle don't need it.  Unless you REALLY need it (Think
terabytes of data), Oracle is like cracking a nut with a sledge hammer.  You
can do it.  But you have to slug around a lot more weight in order to do what
you can accomplish with a nut cracker.  In other words its overly complicated.

-Chris


On Sun, Jul 17, 2005 at 08:06:22AM -0400, Ed Leafe wrote:
> On Jul 15, 2005, at 11:19 PM, William Lodge wrote:
> 
> > Finally, does anybody know of any Web sites having examples of 
> > database apps
> > in Python?
> 
> 	You might want to look at Dabo, which is a database application 
> framework for Python. In about 30 seconds you can create an application 
> that queries a database, displays the results, and allows for 
> editing/updating/inserting/deleting records.
> 
> 	Currently we do not have an ODBC interface, which is what you'd need 
> if the data is in Access, since no one involved has written that 
> module. However, if you are interested in developing your app in Dabo, 
> we'd be glad to add that module as long as you're willing to give us 
> the feedback we need to get it working smoothly.
> 
> 	BTW, I wouldn't suggest scaling up to Oracle - why get involved with 
> all that licensing? There are many open-source databases, such as 
> PostgreSQL, MySQL and Firebird that can handle large data sets without 
> getting stuck with huge license fees.
> 
>       ___/
>      /
>     __/
>    /
>   ____/
>   Ed Leafe
>   http://leafe.com/
>   http://dabodev.com/
> 
> -- 
> http://mail.python.org/mailman/listinfo/python-list