Show HN: Mathesar – open-source collaborative UI for Postgres databases Hi HN! We just released the public alpha version of Mathesar ( https://mathesar.org/ , code: https://ift.tt/l5SbsAI ). Mathesar is an open source tool that provides a spreadsheet-like interface to a PostgreSQL database. I was originally inspired by wanting to build something like Dabble DB. I was in awe of their user experience for working with relational data. There’s plenty of “relational spreadsheet” software out there, but I haven’t been able to find anything with a comparable UX since Twitter shut Dabble DB down. We're a non-profit project. The core team is based out of a US 501(c)(3). Features: * Built on Postgres : Connect to an existing Postgres database or set one up from scratch. * Utilizes Postgres Features : Mathesar’s UI uses Postgres features. e.g. "Links" in the UI are foreign keys in the database. * Set up Data Models : Easily create and update Postgres schemas and tables. * Data Entry : Use our spreadsheet-like interface to view, create, update, and delete table records. * Data Explorer : Use our Data Explorer to build queries without knowing anything about SQL or joins. * Schema Migrations : Transfer columns between tables in two clicks in the UI. * Custom Data Types :: Custom data types for emails and URLs (more coming soon), validated at the database level. Links: CODE: https://ift.tt/l5SbsAI LIVE DEMO: https://ift.tt/jK5kYnq DOCS: https://ift.tt/3XkIOeJ COMMUNITY: https://ift.tt/SFKg68q WEBSITE: https:/mathesar.org/ SPONSOR US: https://ift.tt/XWF5A4x or https://ift.tt/kWflNyi https://ift.tt/l5SbsAI March 3, 2023 at 12:34AM
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