Tag database
8 bookmarks have this tag.
2025-02-13
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;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.
2025-02-02
Просто берите Postgres
grishaev.me/just-use-postgres2024-11-14
Don't Do This - PostgreSQL wiki
wiki.postgresql.org/wiki/Don't_Do_This2024-08-29
There can't be only one
www.b-list.org/weblog/2024/aug/27/highlander-problemThere's a concept that I've heard called by a lot of different names, but my favorite name for it is …
2024-04-26
Soft delete
grishaev.me/soft-delete2023-08-17
File System Alternatives
wiki.c2.com?FileSystemAlternativesI am tired of hierarchical FileSystems. They grow into big messes over time (LimitsOfHierarchies). Let's discuss alternatives. Some have suggested using various kinds of databases so that one can query or view based on a wide variety of potentially orthogonal traits.
The C2 Ancients have good ideas.
P. S. Trying to save this page in Betula shows how bad and unfriendly the new “design” of WikiWikiWeb is.
2023-03-28
Oops, You Wrote a Database
dx.tips/oops-databaseThis is about Mycorrhiza, for sure.