Ask Your Question
2

Database Schemas?

asked 2010-08-20 11:04:37 -0500

this post is marked as community wiki

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?

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
1

answered 2010-08-20 11:57:49 -0500

this post is marked as community wiki

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(
    ...
    
edit flag offensive delete link more

Comments

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

Mike Hansen gravatar imageMike Hansen ( 2010-08-20 12:11:57 -0500 )edit

Your Answer

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

Add Answer

Question Tools

Stats

Asked: 2010-08-20 11:04:37 -0500

Seen: 909 times

Last updated: Aug 20 '10