Differences between revisions 9 and 30 (spanning 21 versions)
Revision 9 as of 2007-06-16 00:31:55
Size: 696
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 5: Line 5:
Robert Miller, David Joyner, Yi Qiang, Emily Kirkman, Tom Boothby Robert Miller, Emily Kirkman, Tom Boothby, David Joyner, Yi Qiang
Line 7: Line 7:
 * GOAL: Create a well thought-out SAGE Enhancement Proposal, and start coding to implement it.  * GOAL: SAGE Enhancement Proposal.
Line 9: Line 9:
 * Issues to brainstorm:    * 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
Line 11: Line 19:
   * SAGE interface to sqlite

   * Uniform database approach within sage
   * Brainless database creation.
Line 25: Line 31:
   * Automagic caching of computation results, keeping those results in portable objects, making these objects merge-able, etc...    * Automagic caching: keep track of computation results

     *
keeping those results in portable objects, making these objects merge-able, etc...
Line 28: Line 36:

   * 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)