Show HN: Sksql a Database Engine in TypeScript Hi! I wanted to understand more about databases' internals so I wrote one from scratch. It has a T-SQL inspired syntax with support for functions and procedures. It can be used stand-alone as a SQL engine or with a server allowing for persistence and replication to other connected clients. Performance are nothing near sqlite of course but that's beside the point. It’s a small database engine that can run in a web app as a way to store session data, do small calculations on a web worker, store the document/data the user is editing or facilitate “multiplayer” feature by broadcasting the queries the web app is running. The server runs in a container for that specific document and shutdowns automatically after a set amount of minutes of inactivity. https://ift.tt/HxA0wfn October 1, 2022 at 09:54PM
Show HN: StreetComplete, an OpenStreetMap Editor for Humans StreetComplete is an OpenStreetMap[0] editor directed at people who want to contribute and want to do this using their smartphone, without learning how to edit things[1]. It is available as an Android application. It is intended to be used as one walks, with quests appearing as markers on the map. Selecting a marker allows one to answer a simple question. The answer will be added to the OpenStreetMap database, with app handling selecting objects for editing, transforming answer into OSM tags and making edits. OpenStreetMap account is needed to apply edits, but it is possible to start without it, make some edits and login/register later. Note: I am not the main author, but I am one of the active contributors. Github page is at https://ift.tt/2g8lasH and https://ift.tt/3nR9PzS shows what was recently released. [0]OpenStreetMap is a Wikipedia of maps, available on the open licence. This dataset is already used for many interestin...
Comments