search

RealTimeWeb / datasets

The primary repository for all of the CORGIS Datasets
GNU General Public License v2.0
20 stars 16 forks source link

SQL Documentation #109

Open acbart opened 7 years ago

acbart commented 7 years ago

We should make a note of the indexes associated with the tables.

mlhDevelopment commented 6 years ago

Also, what flavor of SQL does this represent? I didn't see a particular DBMS mentioned but when I ran it against a MSSQL Server it complained.

acbart commented 6 years ago

Pretty sure SQLite. I recall someone using the CSV format to import data into MySQL - I wonder if that's a better solution for that case? I don't know much about the trade-offs of various SQL data exchange formats.