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 intege
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
On Fri, Aug 30, 2013 at 3:52 PM, Simon Slavin 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
> little, but this is
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 a
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 director
[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
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 goin
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] ~/movie]
[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 d
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 e
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 is
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 describ
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 acr
Fred Williams wrote:
Kind'a like chucking your Pentium 5 and going back to scratching on the
cave wall with a rock, Eh?
I'd export the tables to a CVS files using something like
SQLiteAdmin.exe. Open the CVS files with Excel and save the resulting
spreadsheets as .DBF files (My Excel has a cho
[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 do
[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,
>> modification
[EMAIL PROTECTED] wrote:
> Hi,
> I am pretty much a hard copy guy too. But about a month ago I purchased a
> dual output video card and a second monitor (LCD). Total price $270. Now I
> have the docs on one screen while a work on the other. I like it much better
> than I thought I would.
> Bill
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
>
[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 u
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 use
[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 defen
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 functi
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
[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.
>>>
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 demo
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
> wo
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 goo
[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
[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 PRO
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 begi
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 o
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. Af
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
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?
>
>
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 th
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 f
[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 sta
[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 adde
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;
?colum
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 b
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 true.
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 d
Mark Wyszomierski wrote:
app1:
SomeThread()
{
sqlite3 *db = opendatabase();
writesomestuff();
PostMessage(my_other_app, 0, 0);
closedatabase(db);
return 0;
}
app2:
MessageHandlerInMainThread()
{
sqlite3 *db = opendatabase();
ReadDatabaseStuff(db);
closedatabase();
return 0;
}
Thanks!
Mark
h
Mark Wyszomierski wrote:
I traced this error down a bit, it only appears when using windows'
PostMessage() to communicate between applications. Both applications have
their own database handles for sure. When one app gets some data, it simply
uses PostMessage() to inform the other app that som
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 Redhat
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, whi
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 relea
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
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.
execu
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 suggestio
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).
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=#
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,
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 an
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 fil
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 do
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'
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 yet)
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 just
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
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 ge
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 multi-t
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
allocate
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) .If
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 g
n this code be formally placed into sqlite so that I (and others)
don't have to hack it in if we want to use it in future updates? Like
the original author, I disclaim all copyrights.
--
Dennis Jenkins
74 matches
Mail list logo