Re: SQLite-D alpha is here [did it mention it works at CTFE]

2016-05-29 Thread Stefan Koch via Digitalmars-d-announce
Support for reading Index-Trees and there(WITHOUT ROWID) tables, has landed in master! Now the real fun can start. CTFE Query translation and optimization.

Re: SQLite-D alpha is here [did it mention it works at CTFE]

2016-05-27 Thread Stefan Koch via Digitalmars-d-announce
On Friday, 27 May 2016 at 07:08:30 UTC, Stefan Koch wrote: On Friday, 27 May 2016 at 05:12:33 UTC, Stefan Koch wrote: There is a locking mechanism in SQLite-proper. However SQLite-D currently makes no attempt in looking for the lock-page. Opps I was wrong :) The Lock-page has nothing todo

Re: SQLite-D alpha is here

2016-05-27 Thread Stefan Koch via Digitalmars-d-announce
On Friday, 27 May 2016 at 05:12:33 UTC, Stefan Koch wrote: There is a locking mechanism in SQLite-proper. However SQLite-D currently makes no attempt in looking for the lock-page. Opps I was wrong :) The Lock-page has nothing todo with threading :)

Re: SQLite-D alpha is here

2016-05-26 Thread Stefan Koch via Digitalmars-d-announce
On Friday, 27 May 2016 at 05:03:43 UTC, xenon325 wrote: For example, I have one thread with traditional (slow) SQLite client, which seldom updates data. And another thread which reads data with sqlite-d. Will not program crash or read trash/inconsistent data ? sqlite-d provides no safety

Re: SQLite-D alpha is here

2016-05-26 Thread xenon325 via Digitalmars-d-announce
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. On Thursday, 26 May 2016 at 19:11:50 UTC, Stefan Koch wrote: So, all that sqlite-d does is reading the

Re: SQLite-D alpha is here

2016-05-26 Thread Stefan Koch via Digitalmars-d-announce
On Thursday, 26 May 2016 at 19:35:22 UTC, Suliman wrote: Oh! Look like for all time I misunderstood the purpose of your project. Do you mean that your tool is created not for being SQL compatible driver, but make possible to use D code for iteration with DB? Yes and no, currently it does

Re: SQLite-D alpha is here

2016-05-26 Thread Suliman via Digitalmars-d-announce
On Thursday, 26 May 2016 at 19:11:50 UTC, Stefan Koch wrote: On Thursday, 26 May 2016 at 14:45:58 UTC, Suliman wrote: Could you explain more details? What do you mean by indirection work with data? Sure, I can explain. So, all that sqlite-d does is reading the sqlite-db files. However the

Re: SQLite-D alpha is here

2016-05-26 Thread Stefan Koch via Digitalmars-d-announce
On Thursday, 26 May 2016 at 14:45:58 UTC, Suliman wrote: Could you explain more details? What do you mean by indirection work with data? Sure, I can explain. So, all that sqlite-d does is reading the sqlite-db files. However the proper sqlite does much more: It implements a whole

Re: SQLite-D alpha is here

2016-05-26 Thread Suliman via Digitalmars-d-announce
On Wednesday, 25 May 2016 at 14:10:41 UTC, Stefan Koch wrote: On Wednesday, 25 May 2016 at 06:52:22 UTC, Suliman wrote: Even faster then official version? What about futures, would it possible to make it's 100% compatibility with C version? Not really. The reason why it is faster is

Re: SQLite-D alpha is here

2016-05-25 Thread Stefan Koch via Digitalmars-d-announce
On Wednesday, 25 May 2016 at 03:48:48 UTC, Stefan Koch wrote: This project is currently on the back burner. However in the next days there will be another significant performance improvement :) A 20% performance improvement has landed in master! It is possible that there are more places in

Re: SQLite-D alpha is here

2016-05-25 Thread jmh530 via Digitalmars-d-announce
On Wednesday, 25 May 2016 at 03:48:48 UTC, Stefan Koch wrote: 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.

Re: SQLite-D alpha is here

2016-05-25 Thread Stefan Koch via Digitalmars-d-announce
On Wednesday, 25 May 2016 at 06:52:22 UTC, Suliman wrote: Even faster then official version? What about futures, would it possible to make it's 100% compatibility with C version? Not really. The reason why it is faster is because there is no indirection in working with the data. If I had

Re: SQLite-D alpha is here

2016-05-25 Thread Suliman via Digitalmars-d-announce
On Wednesday, 25 May 2016 at 03:48:48 UTC, Stefan Koch wrote: 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

Re: SQLite-D alpha is here

2016-05-24 Thread Stefan Koch via Digitalmars-d-announce
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

Re: SQLite-D alpha is here

2016-03-08 Thread Stefan Koch via Digitalmars-d-announce
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!

Re: SQLite-D alpha is here

2016-02-29 Thread Stefan Koch via Digitalmars-d-announce
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

Re: SQLite-D alpha is here

2016-02-28 Thread Stefan Koch via Digitalmars-d-announce
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

Re: SQLite-D alpha is here

2016-02-27 Thread Stefan Koch via Digitalmars-d-announce
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

Re: SQLite-D alpha is here

2016-02-27 Thread Adam D. Ruppe via Digitalmars-d-announce
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.

Re: SQLite-D alpha is here

2016-02-27 Thread Suliman via Digitalmars-d-announce
On Saturday, 27 February 2016 at 16:35:05 UTC, ketmar wrote: no. Why?

Re: SQLite-D alpha is here

2016-02-27 Thread ketmar via Digitalmars-d-announce
no.