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: ∃ 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]