[sqlite] autoincrement field

On Thu, 27 Aug 2015 23:40:15 +0200 Jean-Christophe Deschamps wrote: > http://www.sqlite.org/c3ref/last_insert_rowid.html is what you need. Yes, thanks a lot! Lev

[sqlite] autoincrement field

I have a table structure like this: CREATE TABLE padstack ( id INTEGER PRIMARY KEY AUTOINCREMENT, pin_number INTEGER, name TEXT ); Is there any way to get the 'id' of newly inserted row? My insert of course not contains the 'id' field. Thanks, Lev

Re: [sqlite] SQlite on flash filesystem

again by a stupid question. If I do a SELECT... does this performs any disk write operation? I know that sqlite can store the database in RAM. Is there any way to (periodically) write the database to a regular sqlite file? Does sqlite calls 'sync()' after an UPDATE or INSERT? Thanks, Levente

[sqlite] SQlite on flash filesystem

I found that Ext4 with no journaling, mounted with noatime and the nodiratime option is a good choice. Please share your thoughts and experience. Thank you, Levente ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] archive of database

Simon, Tony, Thank you very mucj r your answer! It was helpful. All the best! 73 de HA5OGL -- Levente Kovacs CTO, CSO http://levente.logonex.eu ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

[sqlite] archive of database

? Will it be able to read older version of database? What is the most portable way? Thanks, Levente -- Levente Kovacs CTO, CSO http://levente.logonex.eu ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite