René's URL Explorer Experiment


Title: Stop building databases

Open Graph Title: Stop building databases

X Title: Stop building databases

Description: Join me as we take a look at common application data patterns, and how they relate to the inner-workings of databases. In this post, we discuss data caching, indexing, optimistic mutations, and recursive cache invalidation. We will see how life might be easier if we could just use a frontend optimized database like SQLSync instead.

Open Graph Description: Join me as we take a look at common application data patterns, and how they relate to the inner-workings of databases. In this post, we discuss data caching, indexing, optimistic mutations, and recursive cache invalidation. We will see how life might be easier if we could just use a frontend optimized database like SQLSync instead.

X Description: Join me as we take a look at common application data patterns, and how they relate to the inner-workings of databases. In this post, we discuss data caching, indexing, optimistic mutations, and recursive cache invalidation. We will see how life might be easier if we could just use a frontend optimized database like SQLSync instead.

Opengraph URL: https://sqlsync.dev/posts/stop-building-databases/

Generator: Astro v5.17.1

direct link

Domain: sqlsync.dev

og:typewebsite
og:imagehttps://sqlsync.dev/og/stop-building-databases.png
twitter:cardsummary_large_image
twitter:imagehttps://sqlsync.dev/og/stop-building-databases.png
twitter:urlhttps://sqlsync.dev/posts/stop-building-databases/

Links:

back https://sqlsync.dev/
Carl Sverrehttps://carlsverre.com
The humble cachehttps://sqlsync.dev/posts/stop-building-databases#the-humble-cache
Going faster with indexeshttps://sqlsync.dev/posts/stop-building-databases#going-faster-with-indexes
Glass half-full mutationshttps://sqlsync.dev/posts/stop-building-databases#glass-half-full-mutations
Recursive Cache invalidationhttps://sqlsync.dev/posts/stop-building-databases#recursive-cache-invalidation
Are we building databases?https://sqlsync.dev/posts/stop-building-databases#are-we-building-databases
Let’s talk!https://sqlsync.dev/posts/stop-building-databases#lets-talk
Prior arthttps://sqlsync.dev/posts/stop-building-databases#prior-art
Rifflehttps://sqlsync.dev/posts/stop-building-databases#riffle
Instant.dbhttps://sqlsync.dev/posts/stop-building-databases#instantdb
CR-SQLitehttps://sqlsync.dev/posts/stop-building-databases#cr-sqlite
#https://sqlsync.dev/posts/stop-building-databases#the-humble-cache
React Hookshttps://react.dev/learn
1https://sqlsync.dev/posts/stop-building-databases#user-content-fn-dont-do-this
Reduxhttps://redux.js.org/
#https://sqlsync.dev/posts/stop-building-databases#going-faster-with-indexes
SingleStorehttps://www.singlestore.com
2https://sqlsync.dev/posts/stop-building-databases#user-content-fn-simple-indexes
REST APIhttps://en.wikipedia.org/wiki/REST
3https://sqlsync.dev/posts/stop-building-databases#user-content-fn-index-ways
#https://sqlsync.dev/posts/stop-building-databases#glass-half-full-mutations
#https://sqlsync.dev/posts/stop-building-databases#recursive-cache-invalidation
4https://sqlsync.dev/posts/stop-building-databases#user-content-fn-space
5https://sqlsync.dev/posts/stop-building-databases#user-content-fn-graphql
#https://sqlsync.dev/posts/stop-building-databases#are-we-building-databases
SQLSynchttps://github.com/orbitinghail/sqlsync
SQLitehttps://www.sqlite.org/
6https://sqlsync.dev/posts/stop-building-databases#user-content-fn-sqlite-stats
Githttps://git-scm.com/
Reacthttps://react.dev/
Vuehttps://vuejs.org/
Next.jshttps://nextjs.org/
this Todo apphttps://sqlsync-todo.pages.dev/
60 lines of Rusthttps://github.com/orbitinghail/sqlsync/blob/ba762ce2a10afbb8d7856d26ce5b2f108716e38d/demo/demo-reducer/src/lib.rs
SQL querieshttps://github.com/orbitinghail/sqlsync/blob/ba762ce2a10afbb8d7856d26ce5b2f108716e38d/demo/frontend/src/components/TaskList.tsx#L12
triggershttps://www.sqlite.org/lang_createtrigger.html
foreign keyshttps://www.sqlite.org/foreignkeys.html
constraintshttps://www.sqlite.org/lang_createtable.html#check_constraints
full-text searchhttps://www.sqlite.org/fts5.html
how Redux workshttps://redux.js.org/introduction/core-concepts
Git Rebasehttps://git-scm.com/book/en/v2/Git-Branching-Rebasing
7https://sqlsync.dev/posts/stop-building-databases#user-content-fn-sqlsync-talk
#https://sqlsync.dev/posts/stop-building-databases#lets-talk
starring SQLSync on Githubhttps://github.com/orbitinghail/sqlsync
joining our discordhttps://discord.gg/etFk2N9nzC
emailing mehttps://sqlsync.dev/cdn-cgi/l/email-protection#1b737e7777745b746979726f72757c737a7277357f7e6d
#https://sqlsync.dev/posts/stop-building-databases#prior-art
#https://sqlsync.dev/posts/stop-building-databases#riffle
“Building data-centric apps with a reactive relational database”https://riffle.systems/essays/prelude/
#https://sqlsync.dev/posts/stop-building-databases#instantdb
Database in the Browser, a Spechttps://stopa.io/post/279
A Graph-Based Firebasehttps://stopa.io/post/296
#https://sqlsync.dev/posts/stop-building-databases#cr-sqlite
CR-SQLitehttps://github.com/vlcn-io/cr-sqlite
incremental computationhttps://github.com/vlcn-io/materialite
typed-sqlhttps://github.com/vlcn-io/typed-sql
#https://sqlsync.dev/posts/stop-building-databases#footnote-label
↩https://sqlsync.dev/posts/stop-building-databases#user-content-fnref-dont-do-this
↩https://sqlsync.dev/posts/stop-building-databases#user-content-fnref-simple-indexes
↩https://sqlsync.dev/posts/stop-building-databases#user-content-fnref-index-ways
Some people pretend to be building spaceships while building web apps.https://youtu.be/YgTyS6ccK2o?t=253&si=K0XfX0jGgsWohXIc
↩https://sqlsync.dev/posts/stop-building-databases#user-content-fnref-space
although it’s not perfect eitherhttps://dineshpandiyan.com/blog/graphql-n+1/
↩https://sqlsync.dev/posts/stop-building-databases#user-content-fnref-graphql
top five most deployed software modules of any descriptionhttps://www.sqlite.org/mostdeployed.html
↩https://sqlsync.dev/posts/stop-building-databases#user-content-fnref-sqlite-stats
my talk at WasmCon 2023https://www.youtube.com/watch?v=oLYda9jmNpk
↩https://sqlsync.dev/posts/stop-building-databases#user-content-fnref-sqlsync-talk

Viewport: width=device-width, initial-scale=1

URLs of crawlers that visited me.