[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
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.- 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
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
[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
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
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 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: ??? 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
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] -
[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
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 minimum RAM requirements?
Hi, I would like to use SQLite in an embedded device (MP3 player), but I didn't find any information on minimum RAM requirements. Can anyone give me a rough estimate of how much RAM I will need? 1k/10k/100k/1M? Andreas
Re: [sqlite] SQLite minimum RAM requirements?
Andreas Schwarz [EMAIL PROTECTED] wrote: Hi, I would like to use SQLite in an embedded device (MP3 player), but I didn't find any information on minimum RAM requirements. Can anyone give me a rough estimate of how much RAM I will need? 1k/10k/100k/1M? You can configure it in various ways. Embedded device manufactures tell me that they usually get away with a 4K or 8K stack and 50-60K of heap space. Of course, the more memory you give it, the faster it tends to go. If you can share the heap space with other threads of your product (so that SQLite can use more heap when it needs to but let other processes use that heap when SQLite doesn't need it) then so much the better. Note that version 3.3.x of SQLite has some APIs specifically designed to help support this kind of thing. See: sqlite3_soft_heap_limit sqlite3_release_memory -- D. Richard Hipp [EMAIL PROTECTED]
Re: [sqlite] SQLite minimum RAM requirements?
Hi, The product GoDB uses SqLite and works on a lot of PDA and phoes. And many of these pdas are also mp3 players Bill
