Re: [sqlite] [EXTERNAL] Re: Import data into a temporary table

Follow the link found at the bottom of every message and remove yourself from the list -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Dianne Dunn Gesendet: Freitag, 08. März 2019 01:22 An: SQLite mailing list Betreff: [EX

Re: [sqlite] Import data into a temporary table

On Thursday, 7 March, 2019 17:12, D Burgess wrote: >The big downside of the csv extension, is that no matter what you do >your table ends up with every column with a type of text. >A trap if you are you are using union/except/intersect clauses. You are more or less but not entirely correct. If

Re: [sqlite] Import data into a temporary table

Not sure how I got this please remove me Sent from my iPad > On Mar 7, 2019, at 4:00 PM, Keith Medcalf wrote: > > > On Thursday, 7 March, 2019 14:45, Eric Tsau asked: > >> Is it possible to add the option of importing data into a temporary >> table? > >> Currently you have to create a tempo

Re: [sqlite] Import data into a temporary table

I should have said that "It appears that you are correct, the .import shell command does not know how to create a table in other than the default "main" schema" and that you are requesting this be changed so that the table being imported into does get created in the specified schema if a the ta

Re: [sqlite] Import data into a temporary table

The big downside of the csv extension, is that no matter what you do your table ends up with every column with a type of text. A trap if you are you are using union/except/intersect clauses. On Fri, Mar 8, 2019 at 11:00 AM Keith Medcalf wrote: > > On Thursday, 7 March, 2019 14:45, Eric Tsau as

Re: [sqlite] Import data into a temporary table

On Thursday, 7 March, 2019 14:45, Eric Tsau asked: >Is it possible to add the option of importing data into a temporary >table? >Currently you have to create a temporary table first before importing >to it, or having to drop the table afterwards. >.import dump.csv temp.table >or >.import dump.

Re: [sqlite] Import data into a temporary table

On 7 Mar 2019, at 9:45pm, Eric Tsau wrote: > Is it possible to add the option of importing data into a temporary table? Can you rephrase your request ? You can import data into a temporary table > .import dump.csv temp.table Does this command not work correctly ? Simon. _

[sqlite] Import data into a temporary table

Hi, Is it possible to add the option of importing data into a temporary table? Currently you have to create a temporary table first before importing to it, or having to drop the table afterwards. .import dump.csv temp.table or .import dump.csv attach.table Regards Eric

Re: [sqlite] Safe (atomic) db file snapshot and update

On Wednesday, 6 March, 2019 04:10, Anton Polonskiy wrote: >Scenario 1: >Multiple processes write to foo.db. >I want to do some periodic snapshots. >What is the best way to do this without interrupting/blocking >writers? >sqlite3 foo.db '.backup snapshot.db' ? This is the scenario that "vacuum

Re: [sqlite] Safe (atomic) db file snapshot and update

What method of journaling do you use? WAL? What will be appropriate for my use case? Do they open a connection, read, then close the connection, or do you open a connection, read, read, read, read, until the process is terminated, THEN close the connection? (ie, is the connection open all t