mORMot

Damn my dyslexia I read marmot and thought you meant this unrelated project https://github.com/synopse/mORMot

Here you go: Mormot 1.18 (stable): https://github.com/synopse/mORMot/blob/master/SynCrtSock.pas Mormot 2: https://github.com/synopse/mORMot2/blob/master/src/net/mormo... https://synopse.info/files/html/api-1.18/SynCrtSock.html#THT... https://synopse.info/files/html/Synopse%20mORMot%20Framework... They have multiple client implementations. You can pick the one you like (THTTPClientSocket, TWinHTTP, TWinINET, TCurlHTTP, TWinHttpWebSocketClient).

Yes, this is exactly how mORMot (https://github.com/synopse/mORMot) implements the DB server with SQLite.

Yes, that's a very useful feature to extend the functionalities of SQLite. mORMot (https://github.com/synopse/mORMot) added JSON support to SQLite even before JSON1 was introduced.

You are right! In our Delphi/Pascal community we have https://github.com/synopse/mORMot, which is a full client/server DB, remote ORM and RPC system based on top of SQLite.

or a Free Pascal server (powered by mORMot (https://github.com/synopse/mORMot))? Natively compiled, high performance, and supports almost all OS's and CPU's

or mORMot: https://github.com/synopse/mORMot

Check mORMot (https://github.com/synopse/mORMot), making http request should be as simple as something like: ` discogsJson := HttpGet('https://api.discogs.com/artists/45/releases?page=1&per_page=...'); ` Here: https://github.com/synopse/mORMot/blob/54dd708d25586008260f2...

For question #1, an approach is to build a full-fledged Web/REST server wrapping around SQLite: https://github.com/synopse/mORMot The performance is high!

mORMot is very full-featured and powerful! I'd suggest to start with its rich set of samples (https://github.com/synopse/mORMot/tree/master/SQLite3/Sample...) and this blog: https://tamingthemormot.wordpress.com/

Thanks for sharing your real life experience, as a Delphi developer I've been watching FPC/Lazarus becoming more and more mature over the years, what a exciting thing! If you need an ORM/Web framework, check mORMot out, with the supplied rich set of samples, it's easy to get started: https://github.com/synopse/mORMot/tree/master/SQLite3/Sample...

We use mORMot(https://github.com/synopse/mORMot) to achieve concurrent access. On windows it utilizes the http.sys engine (which is the same used by IIS the Microsoft web server) With FreePascal it also works on Linux .

Agreed, I couldn't recommend mORMot more! Several more notes: - The docs for mORMot is very much lengthy and is not written by a native English speaker, you might feel overwhelmed getting started by reading it, but actually it's very simple to start, with the supplied 33 samples: https://github.com/synopse/mORMot/tree/master/SQLite3/Sample... - with Lazarus/FreePascal, mORMot supports almost all Linux distros, check this forum post: http://synopse.info/forum/viewtopic.php?id=3319 - Check the commit logs of its github repository, see how active the development is. - The FPC/Lazarus foundation (http://foundation.freepascal.org/) was launched several days ago, check the Projects menu - you can expect a lot of modern language features would be added. - The newpascal.org site was launched recently to get you started easily for Linux web devel

In addition to the Brook framework mentioned above, check https://github.com/synopse/mORMot. Maybe start from this blog post by the author: http://blog.synopse.info/post/2015/01/10/mORMot-under-Linux-...