How to flush android's SQLite as in-memory db to sd?

Question

I'm working on my own implementation of slf4 for android which has in-memory db and flushes data to sd when i need it. The reason we have to skip using default android.util.Log is that we need to get logs "if something happens" and android log is already truncated. (Is there any way to configure android log not to truncate records until we know we no need it any more?)

I've found that SQLite can work in in-memory mode when passing null as db name: Using in-memory sqlite android

How can i flush it to sd? Will only diff be flushed or all db will be rewritten? It's important for performance reason.

To be more detailed i'm going to use OrmLite to save and request from db. Probably it's not a good idea because of performance, but we should start with it and switch to raw request if it's not fast enough. Will using OrmLite help to solve it probably (some caches or smth else)?

actually what do you need sqlite for in your own `slf4` logging implementation ? — pskink, Jan 15 '16 at 09:18
to save data in-memory and persistent (after flushed) and requestable — 4ntoine, Jan 15 '16 at 09:35
so what is wrong with `java.util.logging.Logger` and `java.util.logging.Handler` (`java.util.logging.MemoryHandler` most likely)? — pskink, Jan 15 '16 at 09:49
how can i get logs that were written 2 days ago using your approach? — 4ntoine, Jan 15 '16 at 09:56
write a custom `Handler` in order to have a full flexibility where you `publish()` your `LogRecord`s — pskink, Jan 15 '16 at 10:05

score 1 · Answer 1 · answered Jan 15 '16 at 08:47

1

If I understood you, you want to drop new data-log into sd card using SQLite.

If I were you if would use ATTACH command for new SQLite on SD card database and merge tables you wanted with a paticular parameters.

That is,

ATTACH 'dbpath' AS AM;
BEGIN TRANSACTION;
CREATE TABLE AM.tableName0 (<rows>);
INSERT INTO AM.tableName0 (<rows>) SELECT <rows> FROM tableName0 ;
COMMIT;

DETACH DATABASE 'AM';

But I do not think that writing into SD card is very fast.

answered Jan 15 '16 at 08:47

Vyacheslav

26,359
19
112
194

writing performance does not matter. Can i do it using ORMLite? – 4ntoine Jan 15 '16 at 09:09
@4ntoine , i haven't tried but i think this is possible. e.g., http://stackoverflow.com/a/19384624/1979882 – Vyacheslav Jan 15 '16 at 09:13

How to flush android's SQLite as in-memory db to sd?

1 Answers1