Re: [sqlite] insert: how to force application to provide value for int primary key?

On Tue, Sep 10, 2019 at 4:32 PM R Smith wrote: > > So "fat" tables, with large rows, and lost of inserts/updates, is > basically > > the worse case > > scenario for such WITHOUT ROWID tables. It works, no issue there, and as > > typical of > > SQLite is often fast enough for most DB sizes, but

Re: [sqlite] insert: how to force application to provide value for int primary key?

On 2019/09/10 2:28 PM, Dominique Devienne wrote: On Tue, Sep 10, 2019 at 2:09 PM Marek Wieckowski wrote: Yes, indeed works. Great, thank you! Note though that it has performance implications perhaps. This changes to physical structure of the table, to be stored as an index basically. So

Re: [sqlite] insert: how to force application to provide value for int primary key?

Dominique Devienne, on Tuesday, September 10, 2019 08:21 AM, wrote... > > On Tue, Sep 10, 2019 at 2:20 PM Jose Isaias Cabrera, on > wrote: > > > Marek Wieckowski, on Tuesday, September 10, 2019 08:08 AM, wrote... > > > > Make it a WITHOUT ROWID table: > > > > > > > > CREATE TABLE example_table

Re: [sqlite] insert: how to force application to provide value for int primary key?

On Tue, Sep 10, 2019 at 2:09 PM Marek Wieckowski wrote: > Yes, indeed works. Great, thank you! > Note though that it has performance implications perhaps. This changes to physical structure of the table, to be stored as an index basically. So if you do lots of insertions "in the middle", you

Re: [sqlite] insert: how to force application to provide value for int primary key?

On Tue, Sep 10, 2019 at 2:20 PM Jose Isaias Cabrera wrote: > Marek Wieckowski, on Tuesday, September 10, 2019 08:08 AM, wrote... > > > Make it a WITHOUT ROWID table: > > > > > > CREATE TABLE example_table ( > > >id INTEGER PRIMARY KEY, > > >description TEXT NOT NULL > > >

Re: [sqlite] insert: how to force application to provide value for int primary key?

Marek Wieckowski, on Tuesday, September 10, 2019 08:08 AM, wrote... > > Yes, indeed works. Great, thank you! > > Marek > > > On Tue, Sep 10, 2019 at 9:13 AM Richard Hipp, on > > > On 9/10/19, Marek Wieckowski, on > > > > > > Is there a way in sqlite to ensure (on the database side) that all > >

Re: [sqlite] insert: how to force application to provide value for int primary key?

Yes, indeed works. Great, thank you! Marek On Tue, Sep 10, 2019 at 9:13 AM Richard Hipp wrote: > On 9/10/19, Marek Wieckowski wrote: > > > > Is there a way in sqlite to ensure (on the database side) that all > inserts > > for such a table have to have explicit values for such a column? > >

Re: [sqlite] insert: how to force application to provide value for int primary key?

On 9/10/19, Marek Wieckowski wrote: > > Is there a way in sqlite to ensure (on the database side) that all inserts > for such a table have to have explicit values for such a column? Make it a WITHOUT ROWID table: CREATE TABLE example_table ( id INTEGER PRIMARY KEY, description