Tag database
10 bookmarks have this tag.
2025-02-14
PostgREST Documentation
docs.postgrest.org/en/v12/index.htmlPostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations.
Sounds like a way to write less code. I skimmed through the reference, looks cool. PostgREST is written in Haskell for some reason though.
Providing HTML Content Using Htmx
docs.postgrest.org/en/v12/how-tos/providing-html-content-using-htmx.htmlHTMX in PostgREST!
create or replace function api.index() returns "text/html" as $$
select $html$
<!DOCTYPE html>
<html>
...
</html>
$html$;
$$ language sql;2025-02-02
Просто берите Postgres
grishaev.me/just-use-postgres2024-11-15
Don't Do This - PostgreSQL wiki
wiki.postgresql.org/wiki/Don't_Do_This2024-04-26
Soft delete
grishaev.me/soft-delete2024-03-24
Redict
redict.ioRedict is a distributed key/value store (a remote dictionary, if you will).
Redict is an independent fork of Redis®1 OSS 7.2.4 licensed under the Lesser GNU General Public license (LGPL-3.0-only). Redict is not affiliated with Redis®.
2023-09-09
Explaining The Postgres Meme
www.avestura.dev/blog/explaining-the-postgres-meme
2023-09-05
PRQL
prql-lang.orgPRQL is a modern language for transforming data
Интересная замена SQL. Запросы для аналитики данных станет писать намного проще. Не думаю, что для чего-то другого этот проект подойдёт. Условный CRUD проще написать, используя именно SQL запросы, здесь PRQL излишен.
2023-07-25
SQL-шпаргалка
antonz.ru/sql-cheatsheetДля всех, кто знал SQL, но подзабыл
2023-07-24
5 Ways to Write a Go Database Model
pboyd.io/posts/5-ways-to-write-a-go-database-modelChoosing the right tools to write a database model in Go can be overwhelming. This post describes the various approaches.