Hi Dominique,

Dominique Devienne <ddevie...@gmail.com> writes:

> On Thu, Aug 29, 2019 at 2:35 PM Jose Isaias Cabrera <jic...@outlook.com>
> wrote:
>
>> Free Ekanayaka, on Thursday, August 29, 2019 06:40 AM, wrote...
>> > See https://dqlite.io for more details.
>>
>> Can dsqlite be installed on Windows?  I went to the site, read the
>> README.md file, and could not find any reference of it.  I can see the
>>
>> $ sudo add-apt-repository -y ppa:dqlite/v1 && sudo apt install dqlite
>>
>> which lets me know that it linux/unix based.  But, is Windows an option
>> also?  Thanks.
>>
>
> Ditto. Wasn't clear is Windows was supported.

Added this as well to the FAQ:

https://github.com/canonical/dqlite/blob/master/doc/faq.md#are-windows-and-osx-supported

> But I'd add whether dqlite could replicate across platforms as well.
> SQLite DB files are portable across platforms and architectures.
> So can dqlite replicate across Windows, Linux, OSX, etc???

As said, yes it's possible, but not done. I don't think it would be too
much work.
>
> Also, does it come in easy-to-digest amalgamation?
> Especially since it requires a patch to SQLite, a portable
> C-amalgamation source distribution form would maximize
> changes of it being tried out.

Good point, I have thought about it but didn't not have time to
implement it. I'll definitely provide that option in the near future.

> Perhaps OT, but would the hooks added to the WAL-journaling
> ever be up-streamed by Richard, under a build flag for example?
> Without it, that's basically "forking" SQLite, which is not
> ideal... --DD

Absolutely. I'd love to upstream it at some point. However I'll wait
until I'm 100% sure of the API, the code and the logic, since Richard
and the team are known to be rightfully very conservative when it comes
to contributions.

One bit that I'd like to explore is to have a bit more replication
options than just WAL pages: for instance you could have some kind of
mixed logical/binary replication that streams the operations peformed on
the btree (e.g. I updated this cell with this value), or statement-based
replication when it makes sense. Ideally a mix of all those approaches
with some euristics to automatically decide which one is the best for a
particular transaction.

Free

> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to