Re: [sqlite] Sqlite on RAM
On Wed, Jun 04, 2008 at 07:58:02AM +1930, Hildemaro Carrasquel scratched on the wall: > Hello.- > > but how can i make a different between all db on RAM if you define as > :memory: ? If you use the SQL command 'ATTACH DATABASE' you name the database. For example: ATTACH DATABASE ':memory:' AS db1; ATTACH DATABASE ':memory:' AS db2; ATTACH DATABASE ':memory:' AS db3; And then you just use the names: CREATE TABLE db1.t (i INTEGER); CREATE TABLE db2.t (i INTEGER); And so on. If you use the sqlite3_open*() interface, each time you open the "file" :memory:, a new database structure will be returned. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite on RAM
All your dbs will have different values. It is a C pointer value not an enumeration value. On Tue, Jun 3, 2008 at 8:28 AM, Hildemaro Carrasquel < [EMAIL PROTECTED]> wrote: > Hello.- > > but how can i make a different between all db on RAM if you define as > :memory: ? > > -- > Ing. Hildemaro Carrasquel > Ingeniero de Proyectos > Cel.: 04164388917/04121832139 > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqlite on RAM
Hello.- but how can i make a different between all db on RAM if you define as :memory: ? -- Ing. Hildemaro Carrasquel Ingeniero de Proyectos Cel.: 04164388917/04121832139 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite on RAM
On 6/2/08, Hildemaro Carrasquel <[EMAIL PROTECTED]> wrote: > Hello.- > > How many db's can i have on RAM? > as many as you want. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqlite on RAM
Hello.- How many db's can i have on RAM? Thanks -- Ing. Hildemaro Carrasquel Ingeniero de Proyectos Cel.: 04164388917/04121832139 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite on RAM
> > > > For windows the easiest thing to do would be setting up the ram disk > and > > > store database there. > > > > easier than using :memory: ??? > > Not easier, but sometimes more useful. Using a RAM disk means going > through the OSes file manager, which adds some overhead. On the > other hand, you can copy the database file to (or from) a more > traditional storage-backed filesystem at any time... something you > can't do with a :memory: database. > I can dump a :memory: db ... but I get your point ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite on RAM
On Tue, May 27, 2008 at 10:41:18PM +0200, Federico Granata scratched on the wall: > > > > For windows the easiest thing to do would be setting up the ram disk and > > store database there. > > easier than using :memory: ??? Not easier, but sometimes more useful. Using a RAM disk means going through the OSes file manager, which adds some overhead. On the other hand, you can copy the database file to (or from) a more traditional storage-backed filesystem at any time... something you can't do with a :memory: database. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite on RAM
> > For windows the easiest thing to do would be setting up the ram disk and > store database there. easier than using :memory: ??? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite on RAM
On Wed, 28 May 2008 13:44:51 +1930, you wrote: >My data Base will run on Linux, Is it possible that? It works the same on all platforms. Igor Tandetnik already pointed out: If you use ":memory:" as a file name in the sqlite3_open() call SQLite creates an in-memory database not backed by disk storage. The same happens in the SQLite command line tool if you do not use a database file name as a commandline parameter. In-memory databases created in this way disappear completely after sqlite3_close(), or after exit program, or after the .quit command in the command line tool. -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqlite on RAM
My data Base will run on Linux, Is it possible that? -- Ing. Hildemaro Carrasquel Ingeniero de Proyectos Cel.: 04164388917/04121832139 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite on RAM
Hildemaro Carrasquel wrote: > Hello.- > > How do i do for running on RAM? > For windows the easiest thing to do would be setting up the ram disk and store database there. http://www.freeramdisk.com/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite on RAM
Hi, Hildemaro Carrasquel wrote: > How do i do for running on RAM? Unless I misunderstand your question, you've already asked: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2008-May/003023.html Weren't the answers useful? -- Dimitri ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite on RAM
At 16:19 10/10/2006, you wrote: Hi List, Is it possible to use SQLite on RAM (where there is no file system) i.e. directly on memory, (No Hard disk). I am planning to use it on RAM inside TV. How it will read and write on RAM. Yes is possible to run SQLite on RAM, we do it 24/7 on a device. What OS will you use? What is TV (not a television, i suppouse)? Do you want the data go out on power off? Or you need data remains on next boot? Do you have direct access to hardware and designs or are you hacking it? Depending in your answers, it may be more or less difficult/easy. - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] SQLite on RAM
Believe so, in this case you would use an 'in memory' database. This can be opened by giving the filename ":memory:". There is more information on the wesite and in the mail archive on this. Personally I have never used this feature, so cant really offer more help than that. > -Original Message- > From: Vivek R [mailto:[EMAIL PROTECTED] > Sent: 10 October 2006 15:19 > To: sqlite-users@sqlite.org > Subject: [sqlite] SQLite on RAM > > > Hi List, > Is it possible to use SQLite on RAM (where there is no file > system) i.e. > directly on memory, (No Hard disk). > I am planning to use it on RAM inside TV. How it will read > and write on > RAM. > > Thanks and Regards, > Vivek R > DISCLAIMER: This information and any attachments contained in this email message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email, and delete the original message immediately. - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] SQLite on RAM
Hi List, Is it possible to use SQLite on RAM (where there is no file system) i.e. directly on memory, (No Hard disk). I am planning to use it on RAM inside TV. How it will read and write on RAM. Thanks and Regards, Vivek R