operations
sqlite-s3-query
Our great sponsors
operations | sqlite-s3-query | |
---|---|---|
12 | 5 | |
98 | 240 | |
- | - | |
5.0 | 7.5 | |
19 days ago | about 2 months ago | |
Python | ||
- | 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.
operations
- Use Preferred Tile.openstreetmap.org URL
- Upcoming downtime on 2023-01-22: WILL NOT allow edits [...] may be unable to login to services which requires openstreetmap.org authentication
-
I made a wiki for comprehensible input resources
I see. It looks like this MediaWiki bug for the mobile site: https://phabricator.wikimedia.org/T274807. I'll try to figure out how to get that fixed.
- Show HN: Query SQLite files stored in S3
-
Is it possible to send area to the backward.
It is strange to me that the pedestrian area gets rendered above the building... would you like to create a topic about this at community.openstreetmap.org ? I think this should be handled differently. I guess the next instance then would be to open an issue at https://github.com/gravitystorm/openstreetmap-carto (probably but I'm not 100% sure) or maybe here https://github.com/openstreetmap/operations
- Host your own OpenStreetMap Map Tiles
-
Tile status info and rerender requests not working anymore.
It was a deliberate decision to disable it for the CDN, on the grounds that with multiple render servers and load balancing, it doesn't do what users would expect anymore, see: https://github.com/openstreetmap/operations/issues/681
- OpenStreetMap looking for more US rendering capacity
- OpenStreetMap: Increase US Rendering Capacity
- Servers
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
What are some alternatives?
planetiler - Flexible tool to build planet-scale vector tilesets from OpenStreetMap data fast
sqlite3vfshttp - Go sqlite3 http vfs: query sqlite databases over http with range headers
openmaptiles-tools - Tools to turn the schema into other formats
athena-sqlite - A SQLite driver for S3 and Amazon Athena 😳
kvtiles - Self hosted maps, PMTiles, MBTiles key value storage and server
tuql - Automatically create a GraphQL server from a SQLite database or a SQL file
mbtiles-php - PHP backend for reading tiles from mbtiles databases
sql.js-httpvfs - Hosting read-only SQLite databases on static file hosters like Github Pages
s3sqlite - Query SQLite files in S3 using s3fs
ws4sqlite - Query sqlite via json+http
verneuil - Verneuil is a VFS extension for SQLite that asynchronously replicates databases to S3-compatible blob stores.
ngx_http_mbtiles_module - A nginx module to serve map tiles directly from mbtiles container files