[Gambas-user] SQLite memory database

tobias tobiasboe1 at ...20...
Wed Nov 3 22:08:47 CET 2010


tobias schrieb:
> good evening,
> i have a more sqlite related question:
> what does it mean in the doc: For SQLite, you can also create and use a 
> database in memory by giving as database name the string ":memory:". 
> (from gambas2 doc, gb.db.connection.name)
> 
> what is creating a database in memory?? simply a temporary database or 
> is that a special term used with sqlite??
> what is the difference (with Connection.Type = "sqlite3") between
> Connection.Name = "" (which means /tmp/sqlite.db)
> and
> Connection.Name = ":memory:"??
> just that there is a temporary file in the first case and in the second 
> everything is done in memory??
> 
> ------------------------------------------------------------------------------
> Achieve Improved Network Security with IP and DNS Reputation.
> Defend against bad network traffic, including botnets, malware, 
> phishing sites, and compromised hosts - saving your company time, 
> money, and embarrassment.   Learn More! 
> http://p.sf.net/sfu/hpdev2dev-nov
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user

ok, i found the information at sqlite.com




More information about the User mailing list