hi,
you could try
http://greschenz.dyndns.org/downloads/sqlite_crypt.zip
bye, gg
Am 08.01.2011 11:59, schrieb Marco Turco:
> Hi all,
> I am looking for a Crypto lib to encrypt the Sqlite Db in full but I would
> like something less expensive that provided from the Sqlite author.
> I have fo
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 ma
*) 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 Tud
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 secon
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 te
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)
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 teste
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 inter
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 unti
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
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
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 f
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 t
his is a test'), 'foo', 'bar')
insert into test values(encrypt('this is test 2'), 'foo2', 'bar2')
...
select decrypt(x) x, y, z from test where decrypt(x) like 'this%'
cu, gg
Igor Tandetnik schrieb:
Günter Greschenz <
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
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
s.org/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 crea
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 ot
P Kishor schrieb:
On 10/20/06, Paul M <[EMAIL PROTECTED]> wrote:
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.html";.
> this version uses threads for sen
idermonkey-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
ook 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-lan
schrieb:
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 i
= '[EMAIL PROTECTED]'
mail.subject = 'Hello';
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
realised 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 si
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 avail
ces the 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
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 wit
erest 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 pr
hi,
i dont know if anyone is interested in my new open source project...
i implemented a little webserver with javascript as backend-language
(1.7 from mozilla 2.0.rc1) and sqlite as datastorage (3.3.7)
the server is serving himself on "http://greschenz.dyndns.org"; :-)
the source can be download
29 matches
Mail list logo
