New answers tagged sqlite
So, this is an MCQ (Multiple Choice Questionnaire) a test where users will only take it once there are time constraints I think that you've over-engineered on your first pass - you woudn't be the first! :-) A preliminary proposal would be be as follows: CREATE TABLE Student (Student_ID int, Name VARCHAR(25)); CREATE TABLE Question (Question_ID int, ...
SQLite 3.9 introduced a new extension (JSON1) that allows you to easily work with JSON data . Also, it introduced support for indexes on expressions, which (in my understanding) should allow you to define indexes on your JSON data as well.
"Millions of columns"? Or millions of rows? For single user applications and just a few megabytes of data, sqlite can be perfectly sufficient, so it will really depend on how many lines of code/rows of data you'll be dealing with, and the complexity of the queries that you'll require. You may want to consider postgresql or mysql from the get go, to avoid ...
I found that sqlite3 custom init script can have meta-command as well as SQL statement: #!/bin/sh commandfile=$(mktemp) # create temporary init script cat <<EOF > $commandfile .mode csv tablename .import /dev/stdin tablename EOF # import bzip2 -d -c huge_compressed.csv.bz2 | sqlite3 --init $commandfile dbname.db
Top 50 recent answers are included