On Mon, Nov 3, 2014 at 11:08 AM, <tone.ga...@whimbrel.com> wrote: > 1. Is there an OR/M framework that works with wxWidgets and SQLite3 > that I just haven't found?
Not that I'm aware of. > 2. If not 1), then does approach of rolling my own make the most sense? Most likely not, but I think only you are going to be able to answer this one. > 3. How do you handle such things? The obvious benefit of wxSQLite is the automatic conversion of strings to wxStrings, but generally speaking, the recommended approach for wxWidgets applications is to only use wxString and other UI-specific data containers when interacting with UI components and controls, and to do the conversion only then. Otherwise it should be in whatever native format you're using for internal operations, and serialization. There's a pretty good chance that projects like LiteSQL and others provide features and functionality you'd never be able to provide in your own rolled version, or match their performance using wxWidgets data containers that are decently fast, but still optimized for use with user interface components. If you're expecting to build out a resource heavy DB implementation, I'd really give those more mature and native ORMs a chance, and find some simple solutions for converting and displaying that data on demand. Then again, you're using SQLite, which is already a step down from more powerful DB engines. SQLite is good for extremely simple relational DBs, but if you think you need a full ORM to wrap a much less simple DB, there's a decent chance you shouldn't be using SQLite at all. -- Regards, Bryan Petty ------------------------------------------------------------------------------ _______________________________________________ wxCode-users mailing list wxCode-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wxcode-users
