SQLite: how to open existing database in memory

[Glen Bojsza]

Essentially, I want to keep the database in its original form / content.

While the user is running the app I want to be able to make changes to the
database knowing that the changes are done in memory and will not be
written to the original database.

I could duplicate the database to a folder on the disk and then later
remove it but if I can do it just in memory and it automatically cleans out
after the user quits the app then it would be more convenient.

For example, if I don't the user to be able to look into the database
(which I believe can be done if it is written to disk) using in memory
would be the way to go...true?

On Sat, Oct 17, 2015 at 12:55 PM, Peter Haworth <pete at lcsql.com> wrote:

> No, no name is available because you have to use ":memory" as the name to
> indicate it is an in-memory db.
>
> Maybe if you explain what it is you're trying to achieve, we can help more.
>
> Pete
> lcSQL Software <http://www.lcsql.com>
> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>
> On Sat, Oct 17, 2015 at 9:42 AM, Glen Bojsza <gbojsza at gmail.com> wrote:
>
> > Thanks for the clarification...this changes the direction I need to take.
> >
> > In creating an in memory database can you create one with a name?
> >
> >
> > On Sat, Oct 17, 2015 at 12:25 PM, Peter Haworth <pete at lcsql.com> wrote:
> >
> > > Sorry, I should have looked at your syntax more closely.
> > >
> > > You can't open an existing database as an in memory database.  If you
> > want
> > > to open an in memory database, the revopendatabase syntax is
> > > revOpenDatabase("sqlite",":memory:") and it will be a brand new, empty
> > > database with no tables.  The syntax you used would have created a disk
> > > database file named /Users/Dev/Documents/Ratings.db3:memory: with no
> > tables
> > > in it, hence the error message you got.
> > >
> > > Hope that explains it better.
> > >
> > >
> > >
> > > Pete
> > > lcSQL Software <http://www.lcsql.com>
> > > Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> > > SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
> > >
> > >
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>