Re: [sqlite] sequencer

[Peter Da Silva]

Have a look at https://sqlite.org/autoinc.html

Also keep in mind that latency for SQLITE is low, since it’s not client-server, 
so you can script a transaction that has any sequence behavior you want with 
similar overhead to having SQLITE implement the sequence for you.

On 8/2/17, 10:23 AM, "sqlite-users on behalf of Sylvain Pointeau" 
<sqlite-users-boun...@mailinglists.sqlite.org on behalf of 
sylvain.point...@gmail.com> wrote:

    Dear all,
    
    I am currently using H2 and I use sequencers like:
    
    CREATE SEQUENCE IF NOT EXISTS SEQ_1 START WITH 12123;
    
    insert into MYTABLE(SPECIFIED_NUMBER, OTHERINFO) values (seq_1.nextval,
    'other info')
    
    I would like to move to sqlite, but what would be your advice for the
    sequencer values?
    Is it possible at all?
    
    Best regards,
    Sylvain
    _______________________________________________
    sqlite-users mailing list
    sqlite-users@mailinglists.sqlite.org
    http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
    

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users