Thanks for the feedback. The schema would indeed be fixed. It sounds like I have an 'interesting' side project in my future!
> -----Original Message----- > From: sqlite-users > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Hick Gunter > Sent: Monday, April 16, 2018 1:50 AM > To: 'SQLite mailing list' > Subject: Re: [sqlite] [EXTERNAL] kooky thought: a vm-only > build (for embedded). feasible? > > > There have been some inquries on the list into executing > pre-generated bytecode. If you have a fixed schema you may be > able to create a valid sqlite3_stmt pointer from bytecode > stored somewhere. > > -----Ursprüngliche Nachricht----- > Von: sqlite-users > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im > Auftrag von dave > Gesendet: Sonntag, 15. April 2018 20:55 > An: sqlite-users@mailinglists.sqlite.org > Betreff: [EXTERNAL] [sqlite] kooky thought: a vm-only build > (for embedded). feasible? > > I had a stray thought, and wanted to ask if it's been thunk > before,and if so what is the thinking? Or just for commentary. > > I have been building a system, part of which uses sqlite and > virtual tables. > This is working great in a desktop/mobile environment. > However, eventually one day, I will want to migrate aspects > of the product to deeply embedded systems (e.g. something > like an STM32F4 class chip), and am thinking about size -- > both code and RAM. I know about the various compile switches > that can turn off various features, but I wonder if I can > really strip it down further by eliminating parsing, query > planning, etc, altogether, and only support the virtual > machine. I do need virtual tables, though. In my particular > use-case, I only need read access -- no create or update. > The thinking being that I can build queries offline and > compile them into the p-code (or whatever it's called), and > either burn those well know queries into flash, or perhaps > send them down the wire as needed. Then of course (maybe > even more critically), can I control ram usage in a > deterministic way such that it will still work on > memory-constrained devices (e.g. having a total of 128 KiB > max for the whole system). > > Anway, has this been discussed before? Or is it a fool's errand? > > Cheers! > > -dave > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___________________________________________ > Gunter Hick | Software Engineer | Scientific Games > International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN > 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 > > May be privileged. May be confidential. Please delete if not > the addressee. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users