Re: [sqlite] Question about Practicality of Embedding SQLite on Cortex-M4 Processor

2018-03-04 Thread Fredrik Gustafsson
Hi, from what I've understood you're making this way too complicated. A database would need an index to be able to find the item you want to mark as is_logged. However you are always logging and saving the data in a certain order, so i BTree is just a waste of space (and code). My proposal would

[sqlite] Bug (or feature?) Trailing comment becomes part of column name

2018-03-04 Thread petern
sqlite> .mode column sqlite> SELECT sqlite_source_id()--sql_comment ...> ; sqlite_source_id()--sql_comment 2018-01-22 18:45:57 0c55d179733b46d8d0ba4d88e01a25e10677046ee3da1d5b1581e86726f2alt1 sqlite> SELECT sq