This looks interesting:
http://sqlitedbms.sourceforge.net/index.htm
Alexey would this work for your multi-master replication? Maybe you
modify this to work for the specific task you have in mind.
-Steve
___
sqlite-users mailing list
sqlite-users@sqlite
Matthew:
I simply called tzset() after I extract the timezone file. It worked
like a charm. Thank you very much! I was having a heck of a time
information online.
On Thu, Jun 19, 2008 at 4:53 PM, Matthew L. Creech <[EMAIL PROTECTED]> wrote:
> On Thu, Jun 19, 2008 at 4:35 PM, Matthew L. Creech <
On Thu, Jun 19, 2008 at 4:35 PM, Matthew L. Creech <[EMAIL PROTECTED]> wrote:
>
> I think this behavior is probably due to the way localtime() works in
> glibc. From what I've seen (at least on my embedded ARM-Linux board),
> localtime() only invokes tzset() the first time it's run by an
> applica
On Thu, Jun 19, 2008 at 3:28 PM, Rich Rattanni <[EMAIL PROTECTED]> wrote:
>
> So this email isn't blaming SQLite for my improper timestamps even
> after I set the correct zoneinfo file. I am just trying to
> understand what is going on. Should I assume that my observation of
> 'Set zoneinfo first
All:
I noticed the following when using sqlite to timestamp flags in an
embedded system. I will lay out the tests performed and the results I
got.
First, an overview. I am working with a linux 2.6.26 kernel and
sqlite v3.5.0. For the handling of timezones, I use the zoneinfo
files. /etc/local
В сообщении от Thursday 19 June 2008 21:47:12 Stephen Woodbridge написал(а):
> Alexey Pechnikov wrote:
> > В сообщении от Thursday 19 June 2008 20:23:22 Stephen Woodbridge
написал(а):
> >> Alexey Pechnikov wrote:
> >>> Hello!
> >>>
> >>> Is any method for multy-master replication of SQLite databas
A limited SQL parser is fairly simple. You could write the program and
launch it from a scripting language as a filter program with input and
output piped.
Dennis Cote wrote:
> BareFeet wrote:
>
>>So, before I get too far into it, I figured others of you out there
>>must already have some re
Alexey Pechnikov wrote:
> В сообщении от Thursday 19 June 2008 20:23:22 Stephen Woodbridge написал(а):
>> Alexey Pechnikov wrote:
>>> Hello!
>>>
>>> Is any method for multy-master replication of SQLite databases?
>> http://www.google.com/search?num=100&hl=en&newwindow=1&q=sqlite++replication
>
> A
On Thu, Jun 19, 2008 at 09:20:24AM -0700, Jason Tudor scratched on the wall:
> The blob sizes are about 24KB.
You do understand the command "UPDATE Objects SET Lock = 1" will
update all 12,243 rows, right? And that requires the whole table to
be sucked in off disk, modified, and written bac
The blob sizes are about 24KB.
I downloaded the sqlite3_analyzer, is there any documentation on this? It's
just an executable and when I dbl click I get a console window that
disappears.
Also, the time I gave was wrong, it was closer to 55 seconds. I set the
synchronous flag to 0 (NONE) and the
В сообщении от Thursday 19 June 2008 20:23:22 Stephen Woodbridge написал(а):
> Alexey Pechnikov wrote:
> > Hello!
> >
> > Is any method for multy-master replication of SQLite databases?
>
> http://www.google.com/search?num=100&hl=en&newwindow=1&q=sqlite++replication
Are you really saw solution for
On Jun 19, 2008, at 11:49 AM, Matt Sergeant wrote:
>
> Note that there are some C++ style comments crept back into the code
> (I
> noticed in the amalgamation, so I can't give you a direct pointer to
> them). This causes compile failures on stricter C compilers.
Already been fixed. http://www
On Jun 19, 2008, at 10:49 PM, Matt Sergeant wrote:
> On Wed, 18 Jun 2008 19:58:02 -0400, D. Richard Hipp wrote:
>>
>> On Jun 18, 2008, at 7:12 PM, Andrea Connell wrote:
>>
>>> I want to use the C API with a C++ class but when I try compiling...
>>>
>>> $ aCC -AA +W829 main.cpp sqlite3.c
>>> main.
On Wed, 18 Jun 2008 19:58:02 -0400, D. Richard Hipp wrote:
>
> On Jun 18, 2008, at 7:12 PM, Andrea Connell wrote:
>
>> I want to use the C API with a C++ class but when I try compiling...
>>
>> $ aCC -AA +W829 main.cpp sqlite3.c
>> main.cpp:
>> sqlite3.c:
>> Error 482: "sqlite3.c", line 532 # Ar
Okay that worked, thanks.
Just curious though... I've compiled C and C++ code together many times.
I've never had a problem before since C is basically a subset of C++.
Why doesn't it work here?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of D. Richar
Alexey Pechnikov wrote:
> Hello!
>
> Is any method for multy-master replication of SQLite databases?
>
http://www.google.com/search?num=100&hl=en&newwindow=1&q=sqlite++replication
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8
Hello!
Is any method for multy-master replication of SQLite databases?
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Jun 19, 2008, at 9:17 AM, Jason Tudor wrote:
> Hello Everyone,
>
> I was hoping that someone could explain why my updates are taking so
> long.
> My schema is as follows:
>
> CREATE TABLE Objects (ObjectId INTEGER PRIMARY KEY, Name TEXT, Type
> INTEGER,
> Lock INTEGER, Data BLOB 3DDataId I
flakpit wrote:
>
> The SQL to insert the blob into my database is :
>
> "INSERT INTO archive (docnumber, document) VALUES (?,?)"
>
> How to change the syntax to update a blob field? Is it the same as updating
> normal data or a variant on the above?
You can replace the data using an replace sta
BareFeet wrote:
> So, before I get too far into it, I figured others of you out there
> must already have some regexes that are suitable for this, or know of
> a simpler approach. Or at worst any regex gurus out there that can
> help fine tune the above?
>
Regular expressions are generally
On Wed, 18 Jun 2008, Roger Binns wrote:
> From the few authors I have spoken to, they don't make the index
> themselves. The publisher does it using someone else and you end up with
> junk, and they bill the author for it!
Roger,
That's not always the case. Springer would not hire a professi
Stephen Woodbridge wrote:
>
> Well if the index requires fewer page reads then it should be
> proportionally faster. For example if you can only get 5 rows on a page
> but 25 index entries, you have 1/5 the number of pages to read.
>
Yes, that is true, but this effect is offset by the fact tha
Raphaël KINDT wrote:
>
> All events come sequentially (because it's a time line).
> I can have more than one event during the same time but I use 1 different
> bit to identify each event types.
>
> I think it's important to use this sequential constraint to do the delete
> request.
> But SQLite3
Alexey Pechnikov wrote:
>
> P.S. Is any method for multy-master replication of SQLite databases?
Nothing built in, but I believe several user have developed their own
systems to do this. You would probably be better off asking this
question in a new thread.
Dennis Cote
_
> First, the index is completely unusable.
I'll second that, worst index that I have ever tried to use.
On Wed, Jun 18, 2008 at 11:05 PM, Roger Binns <[EMAIL PROTECTED]> wrote:
> Stefan Arentz wrote:
> > First, the index is completely unusable.
>
> From the few authors I have spoken to, they do
I use a language called PureBasic and am playing with BLOB data. Got data
saving successfully but read in these forums that updating is the same. Yes,
I know it's a compiled statement, saving to database is fine, I can even
view my saved blobs so I know my code works..
The SQL to insert the blob
Hello Everyone,
I was hoping that someone could explain why my updates are taking so long.
My schema is as follows:
CREATE TABLE Objects (ObjectId INTEGER PRIMARY KEY, Name TEXT, Type INTEGER,
Lock INTEGER, Data BLOB 3DDataId INTEGER DEFAULT NULL)
My table has 12,243 rows.
when I execute the fo
First, thanks for all your answers.
I would like to come back to my question (see first post).
All events come sequentially (because it's a time line).
I can have more than one event during the same time but I use 1 different
bit to identify each event types.
I think it's important to use this se
Hi all,
Short question:
Do you have or know where to find some regex (regular expressions) for
parsing SQLite statements such as create table, create trigger etc
into their component parameters?
More detail:
SQLite gives us the Name, Tbl_Name and SQL of create statements via
the SQLite_M
29 matches
Mail list logo