Re: [sqlite] SQLite is a LoC Preferred Format for datasets

Scott Robinson wrote: > What version of SQLite are you using for this? I just did the > following and do not see the string quoted values you are describing: I'm sorry, the example given was just the current one I was using to test the fix. In general I found the application was quoting all

Re: [sqlite] SQLite is a LoC Preferred Format for datasets

On Wed, May 30, 2018 at 12:15 PM, dmp wrote: > DROP TABLE IF EXISTS mySinkDBTable; > CREATE TABLE mySinkDBTable ( > key_id1 INTEGER UNSIGNED NOT NULL, > key_id2 INTEGER UNSIGNED NOT NULL, > text VARCHAR > ); > > -- > -- Dumping data for table mySinkDBTable > -- > > INSERT INTO

Re: [sqlite] SQLite is a LoC Preferred Format for datasets

Suppose outside the subject of this thread, but in the document. Sustainability factors Self-documentation: "The database format incorporates technical and structural metadata needed to interpret and manipulate the data itself. For example, a database file will include the CREATE TABLE

Re: [sqlite] SQLite is a LoC Preferred Format for datasets

On 29 May 2018, at 7:42pm, Richard Hipp wrote: > Thanks to Simon Willison for pointing out that SQLite is a Preferred > Format for datasets according to the US Library of Congress. > https://simonwillison.net/2018/May/28/library-of-congress/ Obviously a good choice, which in no way makes it

[sqlite] SQLite is a LoC Preferred Format for datasets

Thanks to Simon Willison for pointing out that SQLite is a Preferred Format for datasets according to the US Library of Congress. https://simonwillison.net/2018/May/28/library-of-congress/ -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing