|
Size: 540
Comment:
|
Size: 2498
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: |
| * Online databases | * 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}, inplace=False) # hypothetical way to query}}} * proposal: it should create a new Database object, with a separate connection to the same database, and add "number_of_finches = 7" to the query string {{{ D = Database('something.db') D.query({'number_of_finches' : 7}, inplace=True) # hypothetical way to query}}} * proposal: it should add "number_of_finches = 7" to the query string * 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? * is it possible to have multiple connections to the same .db file? [http://www.mail-archive.com/[email protected]/msg24725.html relevant] * 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? * clear_queries * Brainless database creation. |
| Line 11: | Line 38: |
| * cgi web-accessible... | * Databases distributed with sage: Standard databases included with sage should be immutable |
| Line 13: | Line 40: |
| * accessible from SAGE, perhaps hosted at sage.math... | * Online databases * cgi web-accessible... |
| Line 15: | Line 44: |
| * SAGE databases: included in sage | * accessible from SAGE, perhaps hosted at sage.math... |
| Line 17: | Line 46: |
| * SQLite interface | * SQLite servers? |
| Line 19: | Line 48: |
| * 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... * 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] |
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}, inplace=False) # hypothetical way to query- proposal: it should create a new Database object, with a separate connection to the same database, and add "number_of_finches = 7" to the query string
D = Database('something.db') D.query({'number_of_finches' : 7}, inplace=True) # hypothetical way to query - proposal: it should add "number_of_finches = 7" to the query string
- 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?
is it possible to have multiple connections to the same .db file? [http://www.mail-archive.com/[email protected]/msg24725.html relevant]
- 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?
- clear_queries
- 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]