Differences between revisions 1 and 29 (spanning 28 versions)
Revision 1 as of 2007-06-15 20:08:02
Size: 40
Editor: anonymous
Comment:
Revision 29 as of 2007-06-16 04:41:06
Size: 1366
Editor: anonymous
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
Describe days4/projects/database here. = 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]

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)