Differences between revisions 41 and 42
Revision 41 as of 2007-06-16 04:52:41
Size: 1972
Editor: anonymous
Comment:
Revision 42 as of 2007-06-16 04:56:11
Size: 2099
Editor: anonymous
Comment:
Deletions are marked like this. Additions are marked like this.
Line 10: Line 10:
     * recursive queries without actually calling sqlite every time
     * query in place, query that creates a new Database object
     * recursive queries without actually calling sqlite every time: queries kept track of by a string...
     * exactly what should the following do?
{{{
D = Database('something.db')
Q = D.query({'number_of_finches' : 7}) # hypothetical way to query
}}}

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
      • recursive queries without actually calling sqlite every time: queries kept track of by a string...
      • exactly what should the following do?

D = Database('something.db')
Q = D.query({'number_of_finches' : 7}) # hypothetical way to query
  • 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?
    • should probably just print a string with database name, number of tables...?
  • save
    •  D.save('my.db')  should copy the class's database file to my.db.

    • should this execute queries first?
  • show
    • for extensions to the Database class, this can be anything, e.g. graph database prints nice table
    • for default database class, what would this do? execute any queries and print the data?

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