On 15 Nov 2013, at 2:20pm, Stephen Chrzanowski <pontia...@gmail.com> wrote:
> The lack of the last_insert function is kind of concerning, especially if > you're making a "Person" list and you're simultaneously adding their > contact info in the next query in your program. You've got no reliable > method of getting information back on the person you're inserted. So, > obviously, you wouldn't use it here. The primary use for "without rowid" is for existence tables. Lists of words and lists of real numbers are good examples. The only thing you'd be using that table for is "I need a list of all the values that exist.". You're probably going to build a big list, then spit them back out again sorted into order. No need for a rowid because the primary key isn't an integer field. For the sort of data in your example, you would want a conventional table with rowids, as you write. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
