<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Jukka,</p>
<p>Thanks for sharing. This seems to be quite a recent addition (end
of 2019 for the start of the public activity), so probably
somewhat a bit experimental, at least probably not as mature as
core SQLite (also reading this comment from a likely early user of
the project which questions some essential design aspects:
<a class="moz-txt-link-freetext" href="https://sqlite.org/cloudsqlite/forumpost/3856ce738d">https://sqlite.org/cloudsqlite/forumpost/3856ce738d</a>). It is
somewhat an hybrid solution between the SQLite we know (mostly for
local usage) and a traditional server-based SQL database, but
actually closer to the former than the later. It doesn't fully
cover multi-user / concurrent scenarios, compared to to a
traditional server-based SQL database, so I'm a bit skeptical one
would want to use that for "enterprise" needs. For read-only
scenarios, I'm not sure how better if would compare to accessing a
regular SQLite3 database through /vsicurl/ , /vsis3/ etc. Probably
not that much (the local deamon that maintain a cached version of
downloaded blocks might help in some scenarios though), but of
course that would need to be tested. The "cloud" term somewhat
brings the usual expectations of "magic" happening on a server (or
many!), but CloudSQlite is really just about remote storage of the
database, so all requests are still processed on the client. If
you run a request without indices, you might end up downloading
the whole database. Or a statement like "UPDATE table SET
some_column = some_value" will definitely require downloading
& re-uploading the whole table.</p>
<p>So I wouldn't say this is useless, as if it was designed, it is
hopefully to serve some particular use cases, but I suspect they
are quite niche and that existing well-known server-based database
solutions are probably a better choice in the general case.<br>
</p>
<p>Even<br>
</p>
<div class="moz-cite-prefix">Le 11/04/2023 à 21:55, Rahkonen Jukka a
écrit :<br>
</div>
<blockquote type="cite"
cite="mid:AM0PR09MB3219F194AA82A099B359F993FD9A9@AM0PR09MB3219.eurprd09.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}span.Shkpostityyli17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">I got a link into </span><a
href="https://sqlite.org/cloudsqlite/doc/trunk/www/index.wiki"
moz-do-not-send="true"><span lang="EN-US">https://sqlite.org/cloudsqlite/doc/trunk/www/index.wiki</span></a><span
lang="EN-US"> in a GeoPackage meeting today and I wonder if
that could be useful for something. Any opinions?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">-Jukka Rahkonen-<o:p></o:p></span></p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>