PostgreSQL 14 Internals
Postgres Professional is a PostgreSQL company delivering Postgres Pro DBMS and all kinds of PostgreSQL professional services worldwide
ParadeDB — Search without a second system
One Postgres for your application data, full-text search, vector retrieval, and aggregations. Home of the pg_search extension.
com.atproto.repo.createRecord | Bluesky
*This endpoint is part of the atproto PDS repository management APIs. Requests usually require authentication (unlike the `com.atproto.sync.*` endpoints), and are made directly to the user's own PDS instance.*
Mastering PostGIS
PostGIS is open source extension onf PostgreSQL object-relational database system that allows GIS objects to be stored and allows querying for information and location services. The aim of this book is to help you master the functionalities offered by PostGIS- from data creation, analysis and output, to ETL and live edits. The book begins with an overview of the key concepts related to spatial database systems and how it applies to Spatial RMDS. You will learn to load different formats into your Postgres instance, investigate the spatial nature of your raster data, and finally export it using built-in functionalities or 3th party tools for backup or representational purposes. Through the course of this book, you will be presented with many examples on how to interact with the database using JavaScript and Node.js. Sample web-based applications interacting with backend PostGIS will also be presented throughout the book, so you can get comfortable with the modern ways of consuming and modifying your spatial data.
astrolabe
This is a tool for browsing AT Protocol ("atproto") repositories and records. You can enter an account identifier or full URI to view content as JSON. It works by fetching data directly from account PDS instances: the data itself is not hosted by this service.
I love atproto bc wdym I can post my @leaflet.pub posts to my @bsky.app and then those can show up immediately on my @blento.app AND people can read these posts from any other compatible atproto blogging site like @pckt.blog ???
Andrew🪴
First ever Leaflet?? And a homelab???
Check out @treethought.xyz’s integration! bsky.app/profile/treethought.xyz/post/…
cam
added @standard.site support to obsidian-atmosphere - Publish notes to @leaflet.pub and @pckt.blog from within obsidian - Browse your subscribed publications and clip to your vault semble and margin interop is so good now that I need to update how I display the two 😄 github.com/treethought/obsidian-atmosphe…
My recollection of this is that even if you just pop a new ATProto account into existence and start spitting out `app.bsky.feed.post` records, they don't show up unless you actually go through a Bluesky onboarding & agreeing to ToS, so they should have an email for you through that process.
pgsky 0.2.0 — the Bluesky client that lives inside PostgreSQL — is now public OAuth, DPoP, timeline, posts, replies, threads, all as SQL procedures and views. Plus a Rust TUI styled like a database admin tool It's early, but we got this :)
GitHub - FormerLab/pgsky: An AT Protocol / Bluesky client implemented as a PostgreSQL extension. The database is the application
github.comAre there any atproto apps that use records from competitors? This ecosystem won't feel open to me until @bsky.app uses something from outside the `app.bsky` namespace as part of its core experience
Are there any atproto apps that use records from competitors? This ecosystem won't feel open to me until @bsky.app uses something from outside the `app.bsky` namespace as part of its core experience
The killer app of atproto is interop
Margin
Margin now supports Semble cards and collections! Support Margin likes, comments, and extension. Also included in this update: New feeds, Popular, Margin, and Semble Check it out at margin.at (Note: Cosmik is working on bringing Margin to Semble, and the update should be here in the next days)
ATmospheric Apps
Things that use ATProto to create their own records (NOT Bluesky clients / Appviews)
import.py
Archivers AT
Brickster — Build anything, together.
BlueHarbor
Kimbia - A training journal that belongs to you.
Currents
