Database Schemas?

Database Schemas?

asked 2010-08-20 18:04:37 +0100

This post is a wiki. Anyone with karma >750 is welcome to improve it.

There are a number of databases in sage, for curves or graphs or what have you. Where can I find the schemas for these?

answered 2010-08-20 18:57:49 +0100

This post is a wiki. Anyone with karma >750 is welcome to improve it.

The elliptic curves database is not a SQL database, so it doesn't have a "schema" as such -- it's just a bunch of Python objects.
for any database that is a sqlite3 database, you could just use sqlite3 (the command line tool) to output the schema for the database (by doing sage -sh then sqlite3 databasefile). You'll have to find the database file in the SAGE_ROOT/data/ directory.
```
sage -sh
cd $SAGE_ROOT/data/graphs/
sqlite3 graphs.db
sqlite> select * from sqlite_master;
table|degrees|degrees|2|CREATE TABLE degrees(
...
```

Comments

You can also run ".schema" from the sqlite command line to get an SQL description of the database schema.

Mike Hansen ( 2010-08-20 19:11:57 +0100 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.