Differences between revisions 1 and 30 (spanning 29 versions)
Revision 1 as of 2007-06-15 20:08:02
Size: 40
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 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)