Differences between revisions 35 and 36
Revision 35 as of 2007-06-16 04:47:15
Size: 1538
Editor: anonymous
Comment:
Revision 36 as of 2007-06-16 04:48:47
Size: 1673
Editor: anonymous
Comment:
Deletions are marked like this. Additions are marked like this.
Line 17: Line 17:
     * print?, save and show?      * print?
     * save
       * {{{D.save('my.db'}}} should copy the class's database file to my.db.
       * should this execute queries first?
     * show?

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
      • print?
      • save
        • D.save('my.db' should copy the class's database file to my.db.

        • should this execute queries first?
      • 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: Standard databases included with sage should be immutable
    • 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
    • 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)