recentpopularlog in


« earlier   
TablePlus | Modern, Native Tool for Database Management
Modern, native client with intuitive GUI tools to create, access, query & edit multiple relational databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, and Redis.
sql  database  app 
yesterday by program247365
postgres-migrations - npm
Stack Overflow style database migrations for PostgreSQL
postgresql  migrations  sql  data  npm  nodejsinteractive 
yesterday by program247365
GitHub - biokoda/actordb: ActorDB distributed SQL database
ActorDB distributed SQL database. Contribute to biokoda/actordb development by creating an account on GitHub.
distributed  sharding  rdbms  sql  opensource  floss  multiserver 
yesterday by gilberto5757
The interesting ideas in Datasette
Publishing read-only data

Datasette provides a read-only API to your data. It makes no attempt to deal with writes. Avoiding writes entirely is fundamental to a plethora of interesting properties, many of which are expanded on further below. In brief:

Hosting web applications with no read/write persistence requirements is incredibly cheap in 2018—often free (both ZEIT Now and a Heroku have generous free tiers). This is a big deal: even having to pay a few dollars a month is enough to dicentivise sharing data, since now you have to figure out who will pay and ensure the payments don’t expire in the future.
Being read-only makes it trivial to scale: just add more instances, each with their own copy of the data. All of the hard problems in scaling web applications that relate to writable data stores can be skipped entirely.
Since the database file is opened using SQLite’s immutable mode, we can accept arbitrary SQL queries with no risk of them corrupting the data.
sqlite  GraphQL  sql  query 
2 days ago by euler
The Internals of PostgreSQL
for database administrators and system developers
postgres  sql 
2 days ago by laiuydfoiu1

Copy this bookmark:

to read