Project

General

Profile

Statistics
| Branch: | Tag: | Revision:

gdp / gdplogd / logd_sqlite.c @ master

History | View | Annotate | Download (41.7 KB)

# Date Author Comment
634e96b7 09/24/2020 12:54 PM Eric Allman

Change one of the SQLite PRAGMA defaults (it doesn't seem to help much).

ed574411 09/23/2020 05:33 PM Eric Allman

Cache INSERT statements for SQLite (it was already done for the reads).

7f0b180f 09/03/2020 03:51 PM Eric Allman

Give better SQLite error reports.

76b104d6 06/18/2019 02:54 PM Eric Allman

Fix a bug that might cause "OK" status codes to be interpreted as not
OK. This would only happen if the OK status included a value between 29
and 31 bits large.

8b91b12d 04/02/2019 05:51 PM Eric Allman

Fix NULL pointer dereference if record hash isn't set --- this shouldn't
happen, but some errors can trigger it.

c70b1607 02/09/2019 07:49 AM Eric Allman

Updates for clean compile on Ubuntu 18.04, including finishing upgrade
of OpenSSL to 1.1.0. Changes were surprisingly large. Bump the patch
number for ease of identification (this version also includes updates
for log creation service).

4d21ef9c 01/26/2019 08:52 PM Eric Allman

Change default SQLite locking mode to NORMAL in an attempt to avoid
strange pauses in operation.

c87dd166 01/23/2019 07:56 AM Eric Allman

Update license date on all files. No functional changes.

537a3cba 01/10/2019 03:27 PM Eric Allman

Make gdp-log-view open the database read-only instead of read-write.

be19c14d 01/06/2019 06:59 PM Eric Allman

First cut at resurrecting log-view (now gdp-log-view) for v2 format.
Still needs some tweaking, but basics work.

92adefd5 11/28/2018 09:00 AM Eric Allman

Split variable swarm.gdplogd.log.dir into swarm.gdp.data.dir (the root
of persistent data) and swarm.gdplogd.log.dir (relative to the other).
This is primarily to make container management easier.

Also, when reading parameter files, allow auto-qualification with the...

b816dcbc 11/14/2018 04:33 PM Eric Allman

Make it easy to set an SQLite "busy timeout" to make concurrent access
to logs more resilient. Use swarm.gdplogd.sqlite.pragma.busy_timeout to
set this (value in milliseconds).

6b23e8a6 08/01/2018 04:15 PM Eric Allman

Change default pragmas to be faster --- but less safe.

cfe1834b 07/12/2018 01:27 PM Eric Allman

Implement transaction hooks to make SQLite more efficient if multiple
records are being appended at the same time.

8f44f781 07/10/2018 01:41 PM Eric Allman

Add gdplogd administrative parameters to tweak SQLite3 pragmas that are
likely to affect performance. They are all named
"swarm.gdplogd.sqlite.pragma." with names (and defaults, where
indicated:

    cache_size
    journal_mode       TRUNCATE...
2fc5d25a 06/23/2018 06:15 PM Eric Allman

Give a reasonable error code if SQLite couldn't open a database file to
avoid bogus "internal error" responses.

0adee9c2 06/23/2018 05:35 PM Eric Allman

If SQLite gives a failure code, make sure the resulting estat is also a
failure code.

23c926fa 06/22/2018 11:08 AM Eric Allman

Some deployed versions of SQLite don't support the SELECT FROM
pragma_ syntax.

fb4aecd7 06/18/2018 06:13 PM Eric Allman

Include timestamp accuracy in database; make some of the "FIXME"
comments more explanatory or remove them as appropriate.

2da682ef 06/18/2018 02:51 PM Eric Allman

Get signatures on APPEND working again. Still incomplete, but handles
the single datum in a request case.

9f6be413 06/15/2018 03:26 PM Eric Allman

Cleanup signature and hash type handling. There's no point in storing
the MD algorithm with each datum since it is fixed per GOB, nor in
passing it over the wire since it is just a blob unless you have either
the secret or public key, either of which contain that information...

6e44c1df 06/14/2018 05:12 PM Eric Allman

Be sure to use ORDER BY in SELECTs so the application gets the data in
the right order.

bd278f2e 06/08/2018 11:45 AM Eric Allman

Snapshot: change physical interface to make more efficient use of SQLite
when retrieving sets. Use this for asynchronous reads.

fdeae6ab 05/25/2018 01:22 PM Eric Allman

Snapshot. Fixes in protobuf format to better deal with reads returning
sets.

8cfe4117 05/25/2018 01:22 PM Eric Allman

It turns out that including a GOB pointer in the datum causes too many
locking problems. Just pass the gob in as needed.

eae1d3ec 05/25/2018 01:22 PM Eric Allman

The grand renaming: GCL is (mostly) gone in favor of GOB and GIN.

31d6906f 05/25/2018 01:22 PM Eric Allman

Get basic subscriptions working again.

9852be60 05/25/2018 01:22 PM Eric Allman

Snapshot: several problems with timestamps and metadata.

72871cfc 05/25/2018 01:22 PM Eric Allman

Checkpoint: basic create, write, read all work. Subscriptions, async
commands, and multireads untested.

b6423859 05/25/2018 01:22 PM Eric Allman

Snapshot: some things working, but more things (notably datum lists)
need more work, including at the protocol level.

fa7cfdb9 05/25/2018 01:22 PM Eric Allman

Snapshot: compiles cleanly with updated protocol and crypto
support, but completely untested.

92243bf4 05/25/2018 01:22 PM Eric Allman

Snapshot in on-disk format conversion from ad hoc files to SQLite
databases. Compiles but is completely untested.