Differences between revisions 29 and 30
Revision 29 as of 2007-06-16 04:41:06
Size: 1366
Editor: anonymous
Comment:
Revision 30 as of 2007-06-16 04:41:23
Size: 1382
Editor: anonymous
Comment:
Deletions are marked like this. Additions are marked like this.
Line 11: Line 11:
{{{ D = Database() }}} creates a new temp database and opens a connection to it
{{{ D = Database('existing.db') }}} opens a connection to 'existing.db'
       *{{{ D = Database() }}} creates a new temp database and opens a connection to it
       *{{{ D = Database('existing.db') }}} opens a connection to 'existing.db'

Databases

[:days4/projects/: Other SAGE Days 4 Projects]

Robert Miller, Emily Kirkman, Tom Boothby, David Joyner, Yi Qiang

  • GOAL: SAGE Enhancement Proposal.
    • unified Database class
      • init establishes connection to sqlite
        •  D = Database()  creates a new temp database and opens a connection to it

        •  D = Database('existing.db')  opens a connection to 'existing.db'

      • create, remove and modify tables
      • copy method - when should this create a new database file?
      • print?, save and show?
      • recursive queries without actually calling sqlite every time
      • query in place, query that creates a new Database object
    • Brainless database creation.
    • Databases distributed with sage
    • Online databases
      • cgi web-accessible...
      • accessible from SAGE, perhaps hosted at sage.math...
      • SQLite servers?
    • Automagic caching: keep track of computation results
      • keeping those results in portable objects, making these objects merge-able, etc...
    • Licensing: \exists DBGPL?

    • Noticing identical database entries
    • Standard databases included with sage should be immutable
    • SAGE [http://www.initd.org/pub/software/pysqlite/doc/usage-guide.html interface] to sqlite [:sqlite-tutorial: creating your own database using sqlite in sage]

days4/projects/database (last edited 2008-11-14 13:42:11 by anonymous)