sample schemas?

4 views
Skip to first unread message

Catherine Devlin

unread,
Sep 14, 2010, 11:24:29 PM9/14/10
to sqlpython
Does anyone have a source for a good sample schema for SQLite?  It should be fairly complex - granted, as much as SQLite will allow - to test out sqlpython functionality against.  I could write my own, but finding a pre-made one would save some time.  I've found Sakila and Pagila for MySQL and postgreSQL, respectively, which should let me expand testing for those nicely.

Thanks!  I'm starting up a new round of development, working out the thicket of connection bugs and also working toward SQLite support.  Most importantly, I'm switching to real-time querying of schema-level information (like the list of tables) while still using individual Gerald classes to build the complex metadata for each database object - that is letting me get out the excessively complex code that tried to run full Gerald schema collection in the background, cache it, etc.  Hopefully we'll have a much-improved release in a month or so.

--
- Catherine

Andy Todd

unread,
Sep 15, 2010, 3:15:00 AM9/15/10
to Catherine Devlin, SQL Python

Catherine,

Here's the one I use for my testing of various bits and bobs. It's not
very complex but it works for me.

YMMV-ly yr's,
Andy
--
From the desk of Andrew J Todd esq - http://www.halfcooked.com/

sqlite_portfolio_ddl.sql

David

unread,
Sep 16, 2010, 10:29:29 AM9/16/10
to sqlp...@googlegroups.com
I run an SQL via HTTP service, offering PostgreSQL databases queryable
via http. We offer a Python DB API 2 library to access these
databases from Python, and indirectly via SQLObject or SQLAlchemy.

Would you be willing to add Rdbhost to the set of SQLPython's
supported databases, if I were to write the necessary integrating
code?

David

> --
> You received this message because you are subscribed to the Google Groups
> "sqlpython" group.
> To post to this group, send email to sqlp...@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlpython+...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlpython?hl=en.
>

--
dke...@travelbyroad.net
Rdbhost -> SQL databases as a webservice [www.rdbhost.com]

Reply all
Reply to author
Forward
0 new messages