RE: [sqlite] Tool to find out the memory usage of a program

2006-09-05 Thread Anish Enos Mathew
Thanks for the reply. Earlier i tried using top and ps. But i dropped it when i came to know that top and ps doent give the accurate memory usage. So I tried with valgring, memcheck etc. But that too didn't give me the desired result. The result of valgrind was more over surprising. The

Re: [sqlite] Stripping a newline character

2006-09-05 Thread Nuno Lucas
On 9/5/06, Rob Richardson <[EMAIL PROTECTED]> wrote: Greetings! I am using a serial communications package that includes a readline() method to talk to a bar-code scanner. Readline() gives me a string whose last character is a newline ('\n'). I am trying to get rid of the newline.

Re: [sqlite] Getting Started With SQLite3

2006-09-05 Thread Jay Sprenkle
> The ".import" command of the command line program that comes with sqlite > works. If you need something that doesn't do check out my program, see > the > links below. You should also check out a text editor that has macros and > regular expression search and replace. 180 lines isn't much harder

Re: [sqlite] Database on usbstick

2006-09-05 Thread David Speck
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

Re: [sqlite] Stripping a newline character

2006-09-05 Thread John Stanton
What language are you using? Rob Richardson wrote: Greetings! I am using a serial communications package that includes a readline() method to talk to a bar-code scanner. Readline() gives me a string whose last character is a newline ('\n'). I am trying to get rid of the newline.

Re: [sqlite] Tool to find out the memory usage of a program

2006-09-05 Thread drh
Sergio 'OKreZ' Agosti <[EMAIL PROTECTED]> wrote: > > see options of ps (man ps) > > > >> I want to find out the total and the peak memory > >> usage of a program(in Linux) > > or try with 'top' > For measuring memory usage (and finding memory leaks) valgrind generally works much better than

Re: [sqlite] Tool to find out the memory usage of a program

2006-09-05 Thread Sergio 'OKreZ' Agosti
see options of ps (man ps) I want to find out the total and the peak memory usage of a program(in Linux) or try with 'top' --- Sergio 'OKreZ' Agosti --- icq: 112421063 msn: [EMAIL PROTECTED] skype: sergio.agosti iChat: sergio.agosti jabber: sergio.agosti

[sqlite] Stripping a newline character

2006-09-05 Thread Rob Richardson
Greetings! I am using a serial communications package that includes a readline() method to talk to a bar-code scanner. Readline() gives me a string whose last character is a newline ('\n'). I am trying to get rid of the newline. MyString.strip('\n') isn't working. It has no effect. How

Re: [sqlite] Tool to find out the memory usage of a program

2006-09-05 Thread Cyril Scetbon
see options of ps (man ps) Anish Enos Mathew a écrit : Hi, I want to find out the total and the peak memory usage of a program(in Linux). Is there any tool to find it out.I am inserting 100,000 rows into a table.I want to find out how much memory it is taking ; both

[sqlite] Enhancing decltype()?

2006-09-05 Thread Robert Simpson
For the last couple months I've been working on the ADO.NET vNext provider for SQLite with support for eSQL, LINQ, etc (aka the Entity Framework). I had a eureka moment today while struggling with the ADO.NET vNext bits as it relates to SQLite's limited type support. I thought I'd share, and see

Re: [sqlite] Database on usbstick

2006-09-05 Thread John Stanton
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

Re: [sqlite] Database on usbstick

2006-09-05 Thread John Stanton
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.

Re: [sqlite] Database on usbstick

2006-09-05 Thread John Stanton
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.

Re: [sqlite] Getting Started With SQLite3

2006-09-05 Thread Dennis Cote
Jay Sprenkle wrote: The ".import" command of the command line program that comes with sqlite works. If you need something that doesn't do check out my program, see the links below. You should also check out a text editor that has macros and regular expression search and replace. 180 lines

Re: [sqlite] pre-compiling prepared statements

2006-09-05 Thread Dennis Cote
chetana bhargav wrote: If any one can explain me correctly what sqlite3_prepare does apart from preparing the statement, and does prepare means generating the byte codes necessary. Chetana, sqlite3_prepare does nothing other than preparing an SQL statement, and yes, that does

Re: [sqlite] Database on usbstick

2006-09-05 Thread Markus Hoenicka
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:

[sqlite] Questions on ANALYZE

2006-09-05 Thread Jonathan Ballet
Hello, I would like to know more on the ANALYZE statement. The SQLite doc isn't very clear on it. We have some databases with large data in it. Running ANALYZE speeds up queries in some databases, but not all. What does it do exactly, what are the effects ? When do I have to run it ? How much

Re: [sqlite] Database on usbstick

2006-09-05 Thread eWobbuh
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 ;)?? >> -- > >

Re: [sqlite] Database on usbstick

2006-09-05 Thread Markus Hoenicka
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

Re: [sqlite] Database on usbstick

2006-09-05 Thread eWobbuh
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.

Re: [sqlite] Database on usbstick

2006-09-05 Thread Mario Frasca
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

Re: [sqlite] Database on usbstick

2006-09-05 Thread P Kishor
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

Re: [sqlite] Database on usbstick

2006-09-05 Thread eWobbuh
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

Re: [sqlite] Database on usbstick

2006-09-05 Thread Sergio 'OKreZ' Agosti
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

Re: [sqlite] Database on usbstick

2006-09-05 Thread eWobbuh
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

Re: [sqlite] Database on usbstick

2006-09-05 Thread Mario Frasca
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

Re: [sqlite] Database on usbstick

2006-09-05 Thread Marco Radaelli
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 >

Re: [sqlite] Best way to compare two databases

2006-09-05 Thread drh
"Juan Perez" <[EMAIL PROTECTED]> wrote: > > I have developed a program that uses a sqlite database. > Until now the users downloaded an entire new version of the > database weekly from the FTP server. > But now the database is too big (about 500.000 records) and i want > to make a database

Re: [sqlite] Database on usbstick

2006-09-05 Thread eWobbuh
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

Re: [sqlite] Database on usbstick

2006-09-05 Thread Mario Frasca
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...

RE: [sqlite] Best way to compare two databases

2006-09-05 Thread Denis Povshedny
Hi Juan! People give you a several advices about alternative solutions. But I try to get back to your original question ("¿how to do, in the best way, the new phase 2?") I suppose that database structure isn't changed and we're talking about tracking data differences only. I also suppose that

Re: [sqlite] Best way to compare two databases

2006-09-05 Thread Juan Perez
2006/9/5, JP <[EMAIL PROTECTED]>: Assumming that the clients will NOT change the original database, I can think of 2 methods: 1. Whole DB: drop all indices, then vacuum, then zip, then propagate. On the clients (suscribers), unzip, re-create all indices. 2. Incremental, add a field to stamp