SQLHeavy is an awesome interface......unfortunately I had to abandon it in my project because there is (or was) a memory leak in SQLHeavy.Query. If you create one, and let it go out of scope, not all the memory is recovered. Search the archive for an example.
Having said that, I was creating tens of thousands of the buggers, which rapidly became an issue on a 4GB VM. If your requirements are less taxing, SQLHeavy is well worth the price of a few K leakage. I ended up swiping all the ideas and writing my own wrapper that did just enough for what I needed....sorry Evan, I'm too thick to fix it properly ;) cheers ant On 21 June 2012 19:24, Evan Nemerson <e...@coeus-group.com> wrote: > On Thu, 2012-06-21 at 10:00 -0400, Brian Duffy wrote: >> Hi everyone, >> >> I need to use sqlite in my app. Does anyone have any experience using the >> sqlheavy wrapper? Does it make working with sqlite in Vala more friendly in >> your experience? Is it kept up to date? > > Discalaimer: I wrote SQLHeavy so I can hardly be considered unbiased, > but I'll try to be. > > I've used SQLHeavy quite a bit in some proprietary software (which is > why I wrote it), and in my experience it really does make SQLite a lot > easier to use. > > As for keeping it up to date, it's not like SQLite is changing heavily > with each release... it's really quite stable, and SQLHeavy doesn't > actually need to change. > > There are a few problems: > > * Asynchronous queries can be problematic, especially when not > serialized. I'm working on rewriting some of the internals to > use Bump [1] to fix that by transparently creating multiple > connections to the database, but my spare time is a bit limited > these days so it is going slowly. > * The ORM generator tool (sqlheavy-gen-orm) is basically crap. > I'm planning on removing it. I do plan to keep the ORM code in > the library(SQLHeavy.Table, Row, etc.), just don't rely on the > sqlheavy-gen-orm command-line tool. > * libsqlheavy-gtk isn't ready for production use yet. > > > [1] http://code.google.com/p/bump > > _______________________________________________ > vala-list mailing list > vala-list@gnome.org > https://mail.gnome.org/mailman/listinfo/vala-list _______________________________________________ vala-list mailing list vala-list@gnome.org https://mail.gnome.org/mailman/listinfo/vala-list
