chromedout64 at yahoo.com wrote: > Will SQLite ever get an UPSERT command similar to other DBMS?
These other DMBSes use a client/server architecture and want to achieve high concurrency. SQLite has no client/server communication overhead, so there is no large downside to using two SQL statements instead. Furthermore, SQLite has no write concurrency, so it does not need an optimized UPSERT locking implementation that avoids interfering with other writers. That said, I'd guess SQLite will get UPSERT if a paying customer wants it. Regards, Clemens
