On Wed, Feb 23, 2011 at 6:17 PM, Jeremy Evans <[email protected]> wrote: > On Feb 23, 5:09 am, Christian MICHON <[email protected]> > wrote: >> Hi, >> >> I've a small app making some mathematic calculations, and to access >> quickly the results in a graphical manner (using jruby + swing), I'm >> using a jdbc in-memory sqlite database. >> >> This is fast, and now I would like to add the possibility for users to >> save the db on the disk directly. >> >> Is it possible to do this with a simple sequel command ? > > There's not a built in command for it. If you need persistence, just > use a file backed database. If you cannot know whether you need > persistence in advance, I would recommend assuming you need it and > just delete the file if not. If you are worried about performance, > just do "DB.synchronous = :off". > > Jeremy >
ok, since there's no internal command, I'll perform the select from the in-memory db and make insertions in the file-based db (using transactions, and your DB.synchronous trick). I want to offer the end-users the choice to save or not, but I want the business logic to be implemented using sequel in-memory features. Thanks -- Christian -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
