So if I am a bsky.social user the content gets stored in their database, and if I have a PDS the content gets stored in my PDS?
Yep. If you look at the repo browser for @bnewbold.net, you can see his blogposts: https://atproto-browser.vercel.app/at/did:plc:44ybard66vv44z...
Some more interesting breadcrumbs (what does it take to implement a repo)
My understanding is that your content gets stored in your database, regardless of PDS host. Bluesky hosts most PDS
I believe each user gets a dedicated sqlite database, or at least a dedicated repo. I recall reading somewhere about the implementation moving to use sqlite
"My" instance of sqlite that they host?
yeah, that is my understanding, if I understand your question correctly.
Of course it is all hidden from view, there is a merkle tree involved, and you probably want to use a higher level client than SQL
This talks about why SQLite and not Postgres
https://github.com/bluesky-social/atproto/discussions/2287
Repository spec:
https://atproto.com/specs/repository
Small program to export:
https://github.com/bluesky-social/cookbook/tree/main/go-repo...
https://github.com/whtwnd/whitewind-blog/tree/main/lexicons/...