This construct does not work in postgresql 9.3.5 (unless I have a typo).
However, I would love for it to work in both Postgresql and Sqlite.
djenkins@ostara ~ $ psql -Upostgres -dcapybara_regtest
psql (9.3.5)
Type help for help.
capybara_regtest=# create table test1 (col1 integer, col2
On Fri, Apr 18, 2014 at 6:32 AM, Christian Smith
csm...@thewrongchristian.org.uk wrote:
On Tue, Apr 01, 2014 at 01:08:59PM +, Harmen de Jong - CoachR Group
B.V. wrote:
We have built our own SQLite database server application and are
considering making this open source. Since there will
On Fri, Aug 30, 2013 at 3:52 PM, Simon Slavin slav...@bigfraud.org wrote:
Great question. If all you are doing is writing (never any UPDATE or
DELETE FROM or DROP) then VACUUM won't save any space in your database
file. It would defragment your database and might thereby increase speed a
I just read the Sqlite mail list exchange between Eduardo Morras and Dr.
Hipp (Header Application-ID list). I was unaware that such a feature
existed. Now that I know, I feel compelled to chase a shiny object :)
I maintain a legacy proprietary payroll processing system (from the 1980s!
Yeah).
http://code.openark.org/blog/mysql/sql-pie-chart
An interesting project. The author seems to have way more fun with SQL
than anyone should. But my first thought was... I wonder if this can be
ported to sqlite?
Dennis Jenkins
Network Security Architect
iStream Financial Services
262
Jay A. Kreibich wrote:
On Wed, May 07, 2008 at 10:25:49PM -0400, Andrew Cunningham scratched on the
wall:
I have doubts that you will be able to get SQLite to work on anything
less than a 32-bit processor.
D. Richard Hipp
I was under the impression as long as the processor
Ulrich Telle wrote:
drh wrote:
I'm still having trouble trying to understand how managing
60 separate code files is perceived to be easier than managing
just 2 files (sqlite3.c and sqlite3.h). It seems to me that
the management problem gets much easier the fewer files there
are to manage.
Dennis Cote wrote:
I don't know enough TCL to know if there is a subtle bug here or not.
I suspect that perhaps the file isn't really being closed until the
script exits.Does this seem possible?
Dennis Cote
Get filemon from www.sysinternals.com. Set a filter to monitor all
files in the
RB Smissaert wrote:
Did you make the alterations to make the dll VB compatible?
Nope. C/C++ all the way.
-
To unsubscribe, send email to [EMAIL PROTECTED]
RB Smissaert wrote:
Thanks, will have a look at that.
Do you know from experience that it will compile OK with VC6++?
I use VC 6.0 and it compiles just fine. I did not follow the
instructions on the web site. I didn't even read them. I just put all
of the C files into a single
Thomas Fjellstrom wrote:
I still wonder about the utility of storing binary data in the db itself.
Maybe it makes it more easy to distribute that way, but how often does one
distribute an entire database in a vendor specific format?
I'm quite interested in hearing people's reasoning for going
[EMAIL PROTECTED] wrote:
Dennis Jenkins [EMAIL PROTECTED] wrote:
these are the settings that our app uses when it creates/opens the sqlite
database:
db.ExecuteImmediate(PRAGMA synchronous=OFF);
With synchronous=OFF, a power failure might result in database
corruption
Jay Sprenkle wrote:
LOL! You should look at a function to determine if a day is a holiday.
Talk about ugly! In some places you literally need to know the weather
and the phase of the moon!
--
[EMAIL PROTECTED] ~/movie]$ pom
The Moon is Waning Gibbous (100% of Full)
[EMAIL PROTECTED]
Jay Sprenkle wrote:
LOL! You should look at a function to determine if a day is a holiday.
Talk about ugly! In some places you literally need to know the weather
and the phase of the moon!
--
[EMAIL PROTECTED] ~/movie]$ pom
The Moon is Waning Gibbous (100% of Full)
[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
QUESTION 3: Suppose there is a schema change and the SQL
statement is automatically reprepared. But the schema change
is such that the SQL is no longer valid. (Perhaps one of the
tables mentioned in a SELECT statement was dropped.) What
error code should sqlite3_step()
If you are seeing different memory usage patterns for identical code
based on if it is run from xinetd or on your command line, then I would
check the process environment that xinetd creates. Maybe some component
that sqlite uses is acting differently based on environment variables?
I
Teg wrote:
Hello Dennis,
I'm, probably going to be offering optional encryption too. Why did
you chose to use the SQLite encryption extensions versus just
encrypting the blobs after you read them back in and before you write
them out?
1) We wanted the entire database encrypted. There
Dennis Jenkins wrote:
Teg wrote:
Hello Dennis,
I'm, probably going to be offering optional encryption too. Why did
you chose to use the SQLite encryption extensions versus just
encrypting the blobs after you read them back in and before you write
them out?
1) We wanted the entire
Jay Sprenkle wrote:
On 9/18/06, Teg [EMAIL PROTECTED] wrote:
Hello Jay,
The whole reason I store files in the DB in the first place is to have
a single package to move around and backup when needed. My
application is storing whole series of PNG and JPG files in the
DB with meta data describing
Will Leshner wrote:
Ah. Ok. It was just a shot in the dark. I've never seen SQLite itself
change its header like that, so I suspect the culprit lies elsewhere.
Most likely, the following is not the cause of your problem, but it's
funny: There was once a virus that did a search and replace
[EMAIL PROTECTED] wrote:
It has been suggested that I add a mutex to every SQLite
database connection. This would cause access to a database
connection to automatically serialize even when two or more
threads try to use that connection at once, thus preventing
problems such as the above.
The
[EMAIL PROTECTED] wrote:
Rob Menegon [EMAIL PROTECTED] wrote:
Not sure whether I understand how this would occur.
The application is not doing or responsible for the updates to the database.
Its only function in life is to retrieve and display data. Updates,
modifications occur via
RohitPatel wrote:
FoxPro supports row level locking. Ofcourse FoxPro creates one file for each
table. There must be some way to implement row level locking. Probable by
locking region in a file or somehow.
Just thinking curiously...how MS could have implemented row level locking in
Hello all,
I would like to know where the best place in sqlite is to patch to
have it record (syslog for unix, OutputDebugString() for windows,
nothing fancy) each time it decides to use an index to satisfy a query.
For that matter, also each time is runs a select query and decided to
not
[EMAIL PROTECTED] wrote:
Dennis Jenkins [EMAIL PROTECTED] wrote:
I would like to know where the best place in sqlite is to patch to
have it record (syslog for unix, OutputDebugString() for windows,
nothing fancy) each time it decides to use an index to satisfy a query
[EMAIL PROTECTED] wrote:
Igor Tandetnik [EMAIL PROTECTED] wrote:
This all works great on Unix. When I use dlopen() to
attach the shared library, the procA() reference in
the shared library is automatically resolved to the
address of procA() in the main program.
On Windows, the
Robert Simpson wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 07, 2006 10:36 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] DLLs containing user-defined SQL functions
It's official then: The lack of sensible shared library
Robert Simpson wrote:
-Original Message-
From: Dennis Jenkins [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 07, 2006 11:46 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] DLLs containing user-defined SQL functions
Robert Simpson wrote:
-Original Message-
From
[EMAIL PROTECTED] wrote:
Dennis Jenkins [EMAIL PROTECTED] wrote:
The Windows way does not seem as powerful as the Unix way. I hate
the M$ operating systems, but I code for them almost every day. So my
next statement isn't so much a defense of Microsoft , but a rebuttal to
your
[EMAIL PROTECTED] wrote:
Nikki Locke [EMAIL PROTECTED] wrote:
3.2.2 will refuse to read a database file created by 3.3.5
unless version 3.3.5 was compiled with -DSQLITE_DEFAULT_FILE_FORMAT=1
or the PRAGMA legacy_file_format=ON pragma is used prior to creating
the database. But if the
Clark Christensen wrote:
And yet somehow, the spammer still managed to get signed up
using a paypal.com address. How did they do that?
--
As others have pointed-out, there's probably a simple autoresponder on many
[EMAIL PROTECTED] mailboxes. It replied, and that was good enough :-)
Dennis Cote wrote:
I think an opt in mechanism with a CAPTCHA to allow an account to
continue to post to the list that is triggered every couple of months
wouldn't be a burden to those actively posting. First time or
occasional poster would receive an email when they try to post that
would
Dennis Cote wrote:
Dennis Jenkins wrote:
Maybe someone could create a simple web site that lets us vote on the
suggestions?
Unfortunately (or perhaps not) Richard runs SQLite and its related
community more like a benevolent dictatorship than a democracy. :-)
I believe he listens
Hello,
I'm going to be light on the details here because I'm not sure how
much I can publically discuss (with respect to the Sqlite3 crypto license).
Out project has been using Sqlite3 v 3.2.1 for a long time, with Dr.
Hipp's encryption extension (purchased 2005-7-11). I am about to
[EMAIL PROTECTED] wrote:
Dennis Jenkins [EMAIL PROTECTED] wrote:
Has the crypto extension been updated since last summer?
Yes. The latest code has been sent to you by private email.
--
D. Richard Hipp [EMAIL PROTECTED]
Thank you. The code seems to have fixed
Brannon King wrote:
The benefits I'm trying to get out of sqlite are the data queries. I
collect a large, sparse 2D array from hardware. The hardware device is
giving me a few GB of data data at 200MB/s. Future hardware versions
will be four times that fast and give me terabytes of data. After
Jay Sprenkle wrote:
Me too!
The two largest database setups I've worked with:
the total of all the call records for a major phone company,
and the cumulative records of most of the drugs bought in
the United States, don't add up to as much as this.
What are you sampling at 1/200th of a
Alexey Belyaev wrote:
Hi!
In current versions sqlite (3.2.7 and later) not enought functions,
for receive information abut free pages count (or used pages count).
I have to use not official methods :(
May I expect that this functions will be introduced in next versions sqlite?
I too
Alexey Belyaev wrote:
I mean freepages.c under not official methods :)
I know. :) I'm hoping that someday it will be officially supported. If
Dr. Hipp feels that it adds unnecessary bloat to the library, then maybe
it can be supported but IFDEFd out by default, and those of us that
want
Jay Sprenkle wrote:
Just out of curiosity why is this data in the database?
I've seen very few applications where the blob is indexed or operated upon
by the database and it's always a pain to deal with it. We always just
left binary data in the file system and stored references to it in the
Essien Essien wrote:
hiya,
I have a code snippet that looks like:
typedef int (*SQLITE3_CLOSE)(sqlite3*);
typedef const char* (*SQLITE3_ERRMSG)(sqlite3*);
typedef int (*SQLITE3_OPEN)(const char*, sqlite3**);
typedef int (*SQLITE3_EXEC) (sqlite3*, const char*, sqlite3_callback, void*,
Ulrich Schöbel wrote:
Hi Richard,
thanks for trying to reproduce my 'problem'.
I'm using Linux 2.6.12 (Ubuntu Breezy Badger, a debian distro),
Tcl/Tk 8.4.12, sqlite 3.3.4, all pretty recent versions.
I made the same tests today with the same results.
Nevertheless, sqlite is by far faster
[EMAIL PROTECTED] wrote:
Every Windows DLL can provide a DllMain function. This function gets called
whenever a thread gets created or destroyed.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dllproc/base/dllmain.asp
Except that not all of us use Sqlite as a DLL. We
[EMAIL PROTECTED] wrote:
The delay seems to coincide with the journal file creation-- it happens after
our first (committed but not yet written to disk) write attempt to the
database, the journal file does not at-the-time exist, and there are 500+
inserts pending with reads rapidly being
Just out of curiosity: Maybe someone can report the result of 'SELECT 5 / 2;'
on MySql, SQLServer, and others?
devl=# SELECT 5 / 2;
?column?
--
2
(1 row)
devl=# select 5.0 / 2;
?column?
2.5000
(1 row)
devl=# select 5 / 2.0;
Christian Smith wrote:
On Wed, 28 Sep 2005, Sid Liu wrote:
Is there a possibility that this Reiser 4 be used on a
file, rather than a file system? Hopefully on Windows?
Reiser FS is a filesystem. It manages files. So it cannot be used on a
file.
Your third statement is not
Jay Sprenkle wrote:
On 9/28/05, Dennis Jenkins [EMAIL PROTECTED] wrote:
Your third statement is not true. On Linux (and FreeBSD, but FreeBSD
does not have Reiser as far as I know) you can treat a regular file as
if it were a filesystem and mount that fiel system via the loop back
device
Mark Allan wrote:
Hi,
I am using SQLite on an embedded software product. The SQLite database file is
saved and read from a NOR flash chip. We have found that the writing of data to
this Flash chip can be quite slow. Therefore we need to minimise the writes
that are made by SQLite.
We have
Rolf Schaeuble wrote:
Hello,
if I understand the whole issue correctly, there is only one reason
why it's not safe to use a sqlite handle in any thread of a process
(as long as only one thread at a time uses it): File locks are tied to
the thread that created them (except this special
Jay Sprenkle wrote:
On 9/13/05, GreatNews [EMAIL PROTECTED] wrote:
Hi D. Richard Hipp,
I'm developing a desktop rss reader using your excellent sqlite engine.
One
issue my users found is that sqlite database can get heavily fragmented
over
time. I'm wondering if it's a viable suggestion
Jay Sprenkle wrote:
On 9/13/05, Dennis Jenkins [EMAIL PROTECTED] wrote:
Even vacuuming won't defrag the file. Disk space is allocated by the OS
and the OS makes no guarantees.
Won't Dr. Hipp's method of making a backup copy also defrag the file?
i.e.
execute begin exclusive
Jay Sprenkle wrote:
On 9/13/05, Dennis Jenkins [EMAIL PROTECTED] wrote:
It depends on lots of things: the OS, the filesystem, the % free space
on the file system, other processes that are causing the OS to allocate
disk blocks. I have noticed that Windows XP totally sucks at keeping
files
Jay Sprenkle wrote:
On 9/13/05, Dennis Jenkins [EMAIL PROTECTED] wrote:
Actually, you can defrag the database file yourself, if you have admin
rights (b/c you need to open a handle to the physical device).
I thought he needed an automated solution to include in his code released
Jay Sprenkle wrote:
I'm glad to see someone is working on this since it was a very noticable
problem for me.
I don't think it will matter what database you use if you're forced to have
it hosted over a network.
As far as I know they all rely on the underlying locking mechanism in the
OS,
From postgresql 8.0.1 on FreeBSD:
syslog-ng=# select NULL is null;
?column?
--
t
(1 row)
syslog-ng=# select (0+NULL) is null;
?column?
--
t
(1 row)
syslog-ng=# select (0) is null;
?column?
--
f
(1 row)
syslog-ng=# create table tmp1 ( a int4 );
CREATE TABLE
syslog-ng=#
Jay Sprenkle wrote:
So, in some cases (explicite addition), NULL + 0 = NULL. (we all know
that NULL != NULL). However, the sum function skips NULLs. This
seems inconsistant.
NULL + 0 is not valid since you can't do a binary operation on only one
number (zero is
a number, NULL is not).
Robert Simpson wrote:
um ... It's a file. You just check to see if the file exists. No
sqlite calls involved.
Robert
That would work in this situation, but what about the inverse? You only
want to open the file IF it already exists.
There is a race condition: where you check for the
Robert Simpson wrote:
sqlite3_open() doesn't create/open a file for exclusive access off the
bat.
If you want to atomically open a file that already exists,
open it yourself and while its open, call sqlite3_open(), then close
your own handle to it.
If you want to atomically create a file
Robert Simpson wrote:
What I say below is in no means trying to be rude or show you (or
anyone) up. I have no idea what your experiences are with Windows or
Unix or Unix-Like operating systems. I'm probably stating things that
almost all of us already know. :)
So? If you open the file,
Edwin Knoppert wrote:
Hmm, but every known file format has an header.
Sqlite has a string, not really a header as it seems.
Sqlite has a header. Part of it is plain text, part binary. You can
learn about it by reading the source code.
Maybe for v4 to implement a real header (if not
Mike Shaver wrote:
On 8/22/05, Edwin Knoppert [EMAIL PROTECTED] wrote:
Hmm, but every known file format has an header.
Sqlite has a string, not really a header as it seems.
Maybe for v4 to implement a real header (if not yet)
A header doesn't need to be encrypted.
(A bit for testing if it's
Mike Shaver wrote:
On 8/22/05, Dennis Jenkins [EMAIL PROTECTED] wrote:
I very much disagree. I want the entire file, header included, to be
encrypted. Sometimes you don't want anyone to know what the file type
is. Security through obscurity is not secure. However, you don't want
to give
Mrs. Brisby wrote:
meanwhile, two threads attempting to multiplex access to a single sqlite
handle are a) bound to be confused, and b) need those resource locks
anyway.
(background: I've been using threads on win32 since 1998. Sometimes to
spread load across multiple CPUs, but usually
Cariotoglou Mike wrote:
*. new feature : support for encrypted databases (WITH the licenced
version of sqlite)
http://www.singular.gr/sqlite/
Awesome! Thanks! I was hoping that you would add encryption support.
:) (We purchased our license a few weeks ago).
However, I am unable to
Dennis Jenkins wrote:
Cariotoglou Mike wrote:
*. new feature : support for encrypted databases (WITH the licenced
version of sqlite)
http://www.singular.gr/sqlite/
Awesome! Thanks! I was hoping that you would add encryption support.
:) (We purchased our license a few weeks ago
Roushan Ali wrote:
Thanks Richard for your reply.
Actually, we have written a windows application which uses four threads.
Each thread may have to add/delete thousands of entries in the database(
for performance reason , we don't want to open/close the database for
each insertion/deletion)
Roushan Ali wrote:
Hi,
Thanks for your response. I don't have any idea how multiple
connection objects work. Can you please tell us something about that.
I wrappered the C interface to SQLite3 via a C++ Class called
CSqlite3. The constructor does NOT open the database, it just
allocates
Andrew Piskorski wrote:
On Fri, Jul 15, 2005 at 04:21:05PM +0300, Cariotoglou Mike wrote:
memory and cpu-wise. on Linux, this is nothing, it can handle it easily.
otoh, 500 threads for windows is business as usual, but threading on
Linux, is , I hear, iffy at best.
Linux runs
Hello.
Several months ago I ported the free pages code from sqlite v2 to
v3. I found the original at [1]. My copy is at [2]. I unsuccessfully
tried to contact the original author.
This code simply computes the amount of slack space in the
database. Our database will sometimes grow
copyrights.
--
Dennis Jenkins
70 matches
Mail list logo
