|
Size: 564
Comment:
|
Size: 2481
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? |
| Line 11: | Line 36: |
| * cgi web-accessible... | * Brainless database creation. |
| Line 13: | Line 38: |
| * accessible from SAGE, perhaps hosted at sage.math... | * Databases distributed with sage: Standard databases included with sage should be immutable |
| Line 15: | Line 40: |
| * SQLite servers? | * Online databases * cgi web-accessible... |
| Line 17: | Line 44: |
| * SAGE databases: included in sage | * accessible from SAGE, perhaps hosted at sage.math... |
| Line 19: | Line 46: |
| * SQLite interface | * SQLite servers? |
| Line 21: | 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?
- 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]
- unified Database class