Hello,

I am happy to announce the official alpha version of sqlite-d!

sqlite-d is a reader for the SQLite File Format 3.

In the future I will implement a SQL-like API on top of it.

Top-notch performance is one of the explicit goals of this project!

please note that currently only the ctfe branch is populated.

I welcome contributions!

Repo-URL : https://github.com/UplinkCoder/sqlite-d

Andrei, would it be possible to replace old etc.c.sqlite3 with new native driver when Stefan will finish work on it?

no.

On Saturday, 27 February 2016 at 16:35:05 UTC, ketmar wrote:
> no.

Why?

On Saturday, 27 February 2016 at 16:54:49 UTC, Suliman wrote:
> Why?

etc.c is for the C interface. This is not the C interface.

Besides, the original code will surely be ahead of features and compatibility for a long time anyway.

On Saturday, 27 February 2016 at 17:03:17 UTC, Adam D. Ruppe wrote:
> On Saturday, 27 February 2016 at 16:54:49 UTC, Suliman wrote:
>> Why?
>
> etc.c is for the C interface. This is not the C interface.
>
> Besides, the original code will surely be ahead of features and compatibility for a long time anyway.

The duration of that time depends heavily on the amount of contributions :)

But the short term goal is not to reinvent SQLite rather to present a file-format compatible alternative.

The big advantage of sqlite-d is that you can write your logic in D without having to worry about generating SQL or converting your data into strings.
However in the long-term I plan to provide SQL support if there is sufficient demand for it.

Right now I am still experimenting with different approaches to make sure the API will not compromise performance.

Also I pushed ctfe to the master-branch now. the repo no longer looks empty.

On Saturday, 27 February 2016 at 16:08:21 UTC, Stefan Koch wrote:
> Hello,
>
> I am happy to announce the official alpha version of sqlite-d!
>
> sqlite-d is a reader for the SQLite File Format 3.
>
> In the future I will implement a SQL-like API on top of it.
>
> Top-notch performance is one of the explicit goals of this project!
>
> please note that currently only the ctfe branch is populated.
>
> I welcome contributions!
>
> Repo-URL : https://github.com/UplinkCoder/sqlite-d

Update I just found another case that cannot be handled properly. It just happens with insanely huge databases.

Also I commited my test-data now... I wonder why nobody said anything about the app failing on startup ...

I made a huge performance improvement sqlite-d is now 6-8 times faster then on the day were it wad able to read the first payloads.

2. I am heavily working on write-support.

3.Sqlite-d will then implement the allocator interface! (although I am flexible on that should it turn out to be a bad idea.

I wish you all a happy day!

On Sunday, 28 February 2016 at 12:14:14 UTC, Stefan Koch wrote:

> Update I just found another case that cannot be handled properly. It just happens with insanely huge databases.

That bug is fixed now!

On Saturday, 27 February 2016 at 16:08:21 UTC, Stefan Koch wrote:
> Hello,
>
> I am happy to announce the official alpha version of sqlite-d!
>
> sqlite-d is a reader for the SQLite File Format 3.
>
> In the future I will implement a SQL-like API on top of it.
>
> Top-notch performance is one of the explicit goals of this project!
>
> please note that currently only the ctfe branch is populated.
>
> I welcome contributions!
>
> Repo-URL : https://github.com/UplinkCoder/sqlite-d

Well not much has changed since I made this announcement.
By fixing a really jarring bug I had a slight performance regression.
But this is still the fastest SQLite reader I know of.

This project is currently on the back burner.
However in the next days there will be another significant performance improvement :)