Try go install -a github.com/mattn/go-sqlite3 which will install the compiled-against-Go-1.3 package into your $GOPATH. Right now, you likely have an older version installed under $GOPATH/pkg/ and therefore Go is recompiling it for every build.
You made an error here: DatabaseControl myDBControl(); You declared a function called myDBControl taking no arguments and returning a DatabaseControl. Object declarations without any constructor arguments must omit the (): DatabaseControl myDBControl; This is related to (but is not precisely) the “most vexing parse”, in that it’s caused by the same language rule that statements … Read more
To allow the VACUUM command to run, change the directory for temporary files to one that has enough free space. SQLite’s documentation says the temporary directory is (in order): whatever is set with the PRAGMA temp_store_directory command; or whatever is set with the SQLITE_TMPDIR environment variable; or whatever is set with the TMPDIR environment variable; … Read more
Update: As of version 3.31.0 (released on 2020-01-22), SQLite supports computed columns so the answer below applies to versions prior to 3.31.0 SQLite doesn’t supported computed columns. However your problem can be solved with a relatively simple SQL Query, you can then create a view to make it appear like a table with the extra … Read more
If you use an auto-increment field, you can easily write this to delete the oldest 100 records: DELETE FROM mytable WHERE id IN (SELECT id FROM mytable ORDER BY id ASC LIMIT 100) Or, if no such field is present, use ROWID: DELETE FROM mytable WHERE ROWID IN (SELECT ROWID FROM mytable ORDER BY ROWID … Read more
Official Python library documentation: Cursor objects Python’s SQLite libraries don’t have prepared statement objects, but they do allow you to use parameterized queries, and to provide more than one set of parameters. Edit: An example of executemany as requested: values_to_insert = [(1,”foo”), (2, “bar”), (3, “baz”)] cursor.executemany(“”” INSERT INTO some_table (‘item_num’, ‘item_name’) VALUES (?, ?)”””, … Read more
Oracle: 64,000. Source MySQL: By default, there is no limit. The MySQL “text protocol” requires that the .NET client library substitute all parameters before sending the command text to the server; there is no server-side limit that can be enforced, and the client has no limit (other than available memory). If using “prepared statements” by … Read more