eWobbuh wrote:
For a database that is write once, read mostly, you probably wouldn't
have a lot of trouble, If I were doing it, I'd try to have most of the
sorting and other manipulations done in regular RAM or on the hard
drive to minimize repeated changes on the stick itself.
The
For a database that is write once, read mostly, you probably wouldn't
have a lot of trouble, If I were doing it, I'd try to have most of the
sorting and other manipulations done in regular RAM or on the hard
drive to minimize repeated changes on the stick itself.
>>
The idea is to read
Last I heard, each location on a flash EEPROM stick is good for about
250,000 write cycles and 10 Meg read cycles. The chips are supposed to
have circuitry in them that balance the usage over the entire surface of
the chip so one cell doesn't wear out a lot faster than the others.
Thus, when
eWobbuh wrote:
Ok thanks. Ill figure it out then. Do you have any idea of it is possible for
a small database to be on a usb stick? Or is this is gonna be horrible slow?
It will not be stunningly fast, but if you use transactions wisely you
will probably find that it can run well.
Sqlite is
eWobbuh wrote:
I still cant find it. Cant find anything about where to look for a database.
Only thing i cant find is the open function, but there you only give the
name of the database. plz help this n00b
You have it. The sqlite3_open is how how access the database. Use its
pathname.
eWobbuh wrote:
Havent try it yet, just wondering if its possible. Do you know how you tell
sqlite where to find a database? havent worked before with it.. only with
mysql
Just use the pathname of the single file which contains the entire
Sqlite DB.
I have to admit that I'm a bit pissed of by your refusal to try out even the
tiniest bit of what you want to know. I assume your bit-wise questions mean
that you want to know one thing: is my database app fast enough using SQLite
off a thumbdrive? Just estimates:
2min: download SQLite
3min:
If you'll give me money i'll try that.
Im not asking to try it for me, just wondering if anyone knows approx.
Markus Hoenicka wrote:
>
> eWobbuh <[EMAIL PROTECTED]>:
>
>>
>> Do you have any idea how many write/read actions a flashcard can take a
>> minute before exploding ;)??
>> --
>
>
eWobbuh <[EMAIL PROTECTED]>:
>
> Do you have any idea how many write/read actions a flashcard can take a
> minute before exploding ;)??
> --
Visit your favourite electronics store, buy a representative sample of each make
and model (say 10 each), write a short program that logs the write/read
Do you have any idea how many write/read actions a flashcard can take a
minute before exploding ;)??
--
View this message in context:
http://www.nabble.com/Database-on-usbstick-tf2219676.html#a6152763
Sent from the SQLite forum at Nabble.com.
Sergio 'OKreZ' Agosti wrote:
On 05/set/06, at 15:03, eWobbuh wrote:
I still cant find it. Cant find anything about where to look for a
database. [...]
The name of the database passed to the open function actually is the
path to the database file
yes, where maybe we could add that
On 9/5/06, eWobbuh <[EMAIL PROTECTED]> wrote:
Ok thanks. Ill figure it out then. Do you have any idea of it is possible for
a small database to be on a usb stick? Or is this is gonna be horrible slow?
you got a pretty smart suggestion earlier that the best way to find
out is to try it out
Ok thanks. Ill figure it out then. Do you have any idea of it is possible for
a small database to be on a usb stick? Or is this is gonna be horrible slow?
--
View this message in context:
http://www.nabble.com/Database-on-usbstick-tf2219676.html#a6151675
Sent from the SQLite forum at
On 05/set/06, at 15:03, eWobbuh wrote:
I still cant find it. Cant find anything about where to look for a
database.
Only thing i cant find is the open function, but there you only
give the
name of the database. plz help this n00b
The name of the database passed to the open function
I still cant find it. Cant find anything about where to look for a database.
Only thing i cant find is the open function, but there you only give the
name of the database. plz help this n00b
--
View this message in context:
http://www.nabble.com/Database-on-usbstick-tf2219676.html#a6151486
Sent
eWobbuh wrote:
Havent try it yet, just wondering if its possible. Do you know how you tell
sqlite where to find a database? havent worked before with it.. only with
mysql
http://www.sqlite.org contains a link to 'documentation'.
the very impatient reader will follow 'sqlite in 5 minutes or
To try is the core of each science ;)
Above all it's the core of Computer Science :)
--- eWobbuh <[EMAIL PROTECTED]> ha scritto:
>
> Havent try it yet, just wondering if its possible.
> Do you know how you tell
> sqlite where to find a database? havent worked
> before with it.. only with
>
Havent try it yet, just wondering if its possible.
--
View this message in context:
http://www.nabble.com/Database-on-usbstick-tf2219676.html#a6149354
Sent from the SQLite forum at Nabble.com.
-
To unsubscribe, send
eWobbuh wrote:
here a sqlite noob. Is it possible in linux to have a sqlite database on a
usb stick which i can acces from an hard disk? On the hard disk runs linux
with sqlite.
have you already tried? I don't think there should be any problems,
except possibly regarding the performance...
19 matches
Mail list logo