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

2018-03-05 Thread Eduardo
On Fri, 2 Mar 2018 19:46:17 + "Obrien, John J" escribió: > Hello, > > > My team is working on a project that involves transmitting sensor data from a > data logger module to a mobile application via Bluetooth. I am interested in > finding a relatively fast, reliable

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

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

2018-03-03 Thread nomad
I can't speak to your other questions, but I have a comment on your first thoughts: > but have prior mobile application development experience. My first > thought is to store the data in a SQLite database table and include > one column called "IsSynchronized" that can store a boolean value to >

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

2018-03-02 Thread Doug Currie
On Fri, Mar 2, 2018 at 2:46 PM, Obrien, John J wrote: > [...] > > To summarize, my question is regarding what direction I should ask the > hardware vendor to take. Does it make sense for them to spend time > optimizing the SAM4S for SQLite or should we consider another

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

2018-03-02 Thread Bob Friesenhahn
If you really only have 160KB of RAM (vs 160MB), then that would be prohibitive. Linux and SQLite are not going to be able to run with 160KB of RAM. Otherwise, it sounds like a fine idea. Bob -- Bob Friesenhahn bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/

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

2018-03-02 Thread Obrien, John J
Hello, My team is working on a project that involves transmitting sensor data from a data logger module to a mobile application via Bluetooth. I am interested in finding a relatively fast, reliable way to store the data that was collected by the data logger. Since we aren't guaranteed to