sqlite-s3-query
com-tiles
| sqlite-s3-query | com-tiles | |
|---|---|---|
| 5 | 2 | |
| 240 | 84 | |
| - | - | |
| 7.5 | 3.1 | |
| about 2 months ago | 6 months ago | |
| Python | TypeScript | |
| MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqlite-s3-query
-
Using Lidar to map tree shadows
Awesome project!
What about hosting the data in an S3 bucket with "Requestor Pays"? You'd only have the storage cost.
Disables anonymous access (so would a Dropbox share) but reduces your cost massively.
https://docs.aws.amazon.com/AmazonS3/latest/userguide/Reques...
You wouldn't necessarily need an SQL frontend as it's readonly anyway, and there are multiple ways of letting SQLite access databases in S3 buckets, e.g. https://github.com/michalc/sqlite-s3-query
-
Show HN: Query SQLite files stored in S3
Aha! This is done in https://github.com/uktrade/mbtiles-s3-server, but using an alternative library to query SQLite on S3, https://github.com/michalc/sqlite-s3-query
(Full disclosure: I wrote most of both of these)
-
Show HN: Mbtiles-S3-server – serve vector map tiles directly from mbtiles on S3
I was wondering how this ran queries against SQLite files in an S3 bucket. Here's the answer - it's using some very clever Python ctypes code to implement that HTTP Range header trick from last year:
https://github.com/michalc/sqlite-s3-query/blob/main/sqlite_...
Here's the inspiration for that: https://github.com/phiresky/sql.js-httpvfs
- Ws4sqlite: Query SQLite via HTTP
- Show HN: SQLite-S3-query – Python function to query a SQLite database on S3
com-tiles
-
COMTiles (Cloud Optimized Map Tiles) hosted on Amazon S3 and Visualized with MapLibre GL JS
This time I examined COMTiles(Cloud Optimized Map Tiles). COMTiles are often compared to PMTiles, but I have the impression that PMTiles are becoming more popular these days. The technology of COMTiles is excellent, but it is not yet easy to introduce because the library is not published in “npm,” and the documentation is incomplete. One of the reasons for PMTiles' popularity is due in part to its extensive documentation. This article will be of some help to those who are considering introducing COMTiles!
-
Show HN: Mbtiles-S3-server – serve vector map tiles directly from mbtiles on S3
Com-tiles[1] also looks pretty good, a bit more optimized than pmtiles.
The whole cloud optimized vector tile/data space is next after COGs (cloud optimized geotiffs). Point-clouds are also getting the index-range-request treatment as COPC[2].
[1] https://github.com/mactrem/com-tiles
What are some alternatives?
sqlite3vfshttp - Go sqlite3 http vfs: query sqlite databases over http with range headers
L7 - 🌎 Large-scale WebGL-powered Geospatial Data Visualization analysis engine.
athena-sqlite - A SQLite driver for S3 and Amazon Athena 😳
mod_mbtiles - Serve tiles with Apache directly from an .mbtiles file
tuql - Automatically create a GraphQL server from a SQLite database or a SQL file
mbtiles-s3-server - Python server to on-the-fly extract and serve vector tiles from an mbtiles file on S3
sql.js-httpvfs - Hosting read-only SQLite databases on static file hosters like Github Pages
ngx_http_mbtiles_module - A nginx module to serve map tiles directly from mbtiles container files
ws4sqlite - Query sqlite via json+http
planetiler - Flexible tool to build planet-scale vector tilesets from OpenStreetMap data fast