[sqlite] very slow inserts

hi everybody, i have the following problem: i've created this table and trigger (no index !): CREATE TABLE msgs (date ntext, type ntext, dir ntext, s integer, f integer, msg ntext); CREATE TRIGGER delete_log after insert on msgs begin delete from msgs where rowid%10=new.rowid%10

Re: [sqlite] Re: very slow inserts

nother way ? you're right, the pc has a lot of other tasks running ! e.g. there is a ms sql server installed and i dont know exactly how much disk-io this server is doing ! thanks a lot ! cu, gg Igor Tandetnik wrote: Günter Greschenz <[EMAIL PROTECTED]> wrote: i've created this t

Re: [sqlite] Looking for a cryptographic library

hi, i've written some sqlite-functions to crypt (blowfish) or compress (bzip) data in sqlite: e.g. insert into blubs values (crypt('data','pwd')) or select from xyz where decompress(data) = 'blablabla' or select from xyz where data = compress('blablabla') ... but you have to wait

Re: [sqlite] Looking for a cryptographic library

ok, no problem... as soon as i am at home again from my business trip, i will move the sources to my webserver so everybody can download it... i will post a message with a link then. nice holidays :-) gg [EMAIL PROTECTED] wrote: Günter: Thanks for yours quick response. Really I'm

Re: [sqlite] Looking for a cryptographic library

hi, after a long time being on a business trip, i finally came home and have now the chance to upload the sources to my webserver: http://greschenz.dyndns.org/sqlite.html these sources have never been in a productive system, i just implemented it for fun... what i want to say: i never

Re: [sqlite] Data encryption

, in response to a similar question, Günter Greschenz sent to this forum a email: hi, i've written some sqlite-functions to crypt (blowfish) or compress (bzip) data in sqlite: e.g. insert into blubs values (crypt('data','pwd')) or select from xyz where decompress(data) = 'blablabla' or select

Re: [sqlite] Data encryption

hi everybody, the magic spell worked, but onky for me, not for my server: at the moment i have problems with my (free) dyndns account. my server (a little nslu2 in my living room) was online for some hours yesterday but disappeared again this morning ... until i solved my problem here are the

Re: [sqlite] Single row insert speeds

hi, i am using a "commit-thread": my application is starting a transaction with "begin" and is inserting a lot of data at random times, a thread is doing "commit" and "begin" every second (while locking the main app of course :-). this runs very fast and in case of crashes i loose only 1

Re: [sqlite] Encryption?

*) for crypting/compression you can have a look at http://www.greschenz.de (look/search for "sqlite" of course :-) i've written 2 (very small) sqlite-functions to support this... if my server is down again, please inform me :-) *) yes, i always use *.sdb (for SqliteDB, what else :-) Jason

Re: [sqlite] new sqlite-based webserver

with response times like that! -Original Message- From: Günter Greschenz [mailto:[EMAIL PROTECTED] Sent: Monday, October 09, 2006 12:04 PM To: sqlite-users@sqlite.org Subject: [sqlite] new sqlite-based webserver hi, i dont know if anyone is interested in my new open source project... i

Re: [sqlite] new sqlite-based webserver

Hi, my server is running at home (300mhz(?), linux (suse 9.3) and has a dsl-(2mbit) connection to the world. running inernally (my laptop connected directly via wlan) its really fast (look at the logfile: http://greschenz.dyndns.org/logsByPath.html), it could be a internal routing problem

Re: [sqlite] new sqlite-based webserver

he byte code. By using compiled byte code the overhead of interpreting a script-type language is avoided. Günter Greschenz wrote: Hi, yes i know, the problem is, its single-threaded (because of protability), so if anyone starts a download with a slow connection, the server is blocked for other

Re: [sqlite] new sqlite-based webserver

hi, its asymetric, its (seen from my home) 2mbit downstream and (i'm not sure) 384kbit upstream (but in any case less than 1mbit). the other direction wout be better for serving (now its better for surfing :-) but for my own purpose it is enough :-) at the end of the year 16mbit could be

Re: [sqlite] new sqlite-based webserver

sed in less than 20K of code. HTML V2 is implemented. There are some old fragments of this program at http://www.viacognis.com/muvm. If you are interested I can dig out the current code and let you have it. Günter Greschenz wrote: Hi, normally i like multithreading, but in this case i like the sim

Re: [sqlite] new sqlite-based webserver

llo'; mail.send() var f = new File('contacts.xml'); var xml = f.readAll(); var sch = new Scheduler(); if(!sch.exists('MyImporter')) { sch.setName('MyImporter'); sch.setInterval(30); // every 30 minutes sch.execute('imports.jsp'); sch.save(); } Just my 2 cents. __ Raymond Irving __ Ray

Re: [sqlite] new sqlite-based webserver

Very nice indeed. Any chance we will see some kind of SourceFourge opening soon? Maybe after adding docs and multithreading capabilities? __ Raymond Irving --- Günter Greschenz <[EMAIL PROTECTED]> wrote: hi raymond, your idea of including other files is already done. there is a functi

Re: [sqlite] new sqlite-based webserver

look at the sqlitebrowser-sample in my source-zip. its not perfectly running (still in work) but you can see how this could be done... cu, gg Günter Greschenz schrieb: hi, i dont know if anyone is interested in my new open source project... i implemented a little webserver with javascript as backend-language

Re: [sqlite] new sqlite-based webserver

onkey-crew ! i "just" glued it together... look at the code sizes: only about 100k is from me (for now) ! cu, gg Paul M schrieb: On 10/20/06, Günter Greschenz <[EMAIL PROTECTED]> wrote: Hi, a new version is available (0.5.1.9) on "http://greschenz.dyndns.org/gas.h

Re: [sqlite] sqlite/js based webserver update to 0.5.2.1.g

Hi, i tried it just 10 secends ago, and it worked ?!? well sometimes i have trouble with my provider (my server is at home)... i will create a second download location (not at home) so these kinds of network problems should be solved: if its not downloadable from my home server, just try the

Re: [sqlite] sqlite/js based webserver update to 0.5.2.1.g

/downloads/gas0521g.zip cu, gg hongdong schrieb: I tried several times,time out always.thanks 2006/11/6, Günter Greschenz <[EMAIL PROTECTED]>: Hi, i tried it just 10 secends ago, and it worked ?!? well sometimes i have trouble with my provider (my server is at home)... i will create a

Re: [sqlite] Date data type

hi, i use numeric values and the sqlite date-functions. example: create table if not exists online (ip integer primary key, date number) insert or replace into online values (12345, julianday('now')) select id, datetime(date, 'localtime') date from online order by date desc limit 100

[sqlite] creating own pragmas

Hi all, i'm using "sqlite3_create_function()" to create own functions in my database. this is a really nice possibility to extend the database with powerful functions. but i did not find a way to create own pragmas like "pragma foo=bar" to pass some global information to my application. i can

Re: [sqlite] Re: creating own pragmas

(x) x, y, z from test where decrypt(x) like 'this%' cu, gg Igor Tandetnik schrieb: Günter Greschenz <[EMAIL PROTECTED]> wrote: i'm using "sqlite3_create_function()" to create own functions in my database. this is a really nice possibility to extend the database with powerful

Re: [sqlite] is blob compression worth it

hi, i've written a field-based compression using bzip2. my experience: the fields must have at least 50 bytes, or the compressed data is bigger ! cu, gg Hickey, Larry schrieb: I have a blob structure which is primarily doubles. Is there anyone with some experience with doing data compression

Re: [sqlite] Re: creating own pragmas

Christian Smith schrieb: Dennis Cote uttered: Igor Tandetnik schrieb: G�nter Greschenz <[EMAIL PROTECTED]> wrote: i'm using "sqlite3_create_function()" to create own functions in my database. this is a really nice possibility to extend the database with powerful functions. but i did not

Re: [sqlite] Encryption?

hi, yes i know, my changed my webserver to lighttpd but i had no time to finish the complete the installation because i'm on a business trip right now :-( but its still working if you know the right urls :-) please try http://greschenz.dyndns.org/index.php for the