Folks, it's happening! I started to work on #SQLite support for #Pongo. Stay tuned, more to come soon! 🤟
#pongo
@rdnt it's great that you're saying that, as that's why I created #Pongo: https://github.com/event-driven-io/Pongo
Together with #Emmet PostgreSQL support it makes it already possible (at least if you're in Node.js space).
See:
- https://event-driven.io/en/emmett_projections_testing/
- https://event-driven.io/en/projections_and_event_metadata/
And more about Pongo internals: https://event-driven.io/en/pongo_behind_the_scenes/
Wiecie, co wyjdzie po połączeniu #MongoDB i #PostgreSQL? #Pongo. Nie żartujemy - jest to biblioteka do Node.js, która umożliwia łączenie się z Postgresem tak, jakby było to Mongo. Niektórym może to ułatwić życie, a inni mogą spojrzeć po prostu z ciekawości.
In my recent article the leitmotif is how to bootstrap CRUD applications with #Pongo.
If you’re not considering using my tool, or Node.js in general, then I believe it could be useful for the second hidden plot.
This practical example was a chance for me to discuss what’s actually CRUD for me. When it’s fine to use it, when not.
I also touched on how it relates to CQRS.
Yes, I believe that you can do CRUD and CQRS at the same time. How come? Read more 👇
https://event-driven.io/en/crud_with_pongo/
2/2
I'm being quite frank about my desire to make working on #Emmett, #Pongo, and other community projects sustainable. I'd like to get enough money from direct work on those projects to fully focus on them and bring more value to you and your projects.
I think that supporting #OpenSource is a win-win for both sides. If you're using or considering using Emmett or Pongo tools, it's also some sort of due diligence to reduce the bus factor and maintain them continuously.
1/
I might never reach full compatibility, as the API can have numerous permutations that I didn't predict. I don't want to block anyone waiting for the new release with the fix. I think that SQL is a decent fallback.
That's why I added a few options for using #SQL in the #Pongo API.
Read more about them in my recent article 👇
https://event-driven.io/en/sql_support_in_pongo/
What are your thoughts?
4/4
Users should get a learning ladder. That's why I optimise the API and tooling for the newbies.
That's why, in #Pongo, I'm trying to join two accessibilities: muscle memory and the Node.js community by reusing the #MongoDB client API and #PostgreSQL operation easiness and familiarity. I think that enables me to ramp up quickly and deliver business value by deploying the first version of your software to production.
2/
In case you missed it, I gathered some thoughts on how, why I’ve built #Pongo, a #Mongodb #NodeJs alternative written with #TypeScript
I had a lot of fun showcasing and explaining #Pongo with @FranckPachot on the #YugabyteDB stream.
We went together to discuss why #Pongo uses #PostgreSQL. Seeing live how that plays with #nodejs and #typescript
We also saw some SQL and explained how JSONB storage works, among many other things.
Check it out here: https://www.youtube.com/watch?v=p-6fpV_GDEs
Leave the feedback afterwards.
Boosting is also appreciated!
I think that I made a good progress on #Pongo shell improvements.
Pongo is my #Nodejs project that allows the use of #PostgreSQL as a document database with # Mongo-compliant syntax.
I think that having a shell gives a good experience, allowing you to just play with tools.
Just try it with:
npx @event-driven-io/pongo@latest shell
Here's how it looks 👇
Check Pongo more here: https://github.com/event-driven-io/Pongo
If you'd like to see what I'm brewing with #Pongo, so using PostgreSQL as a strongly-consistent Document Database in #nodejs and #typescript, check the video https://www.youtube.com/live/P4r19rv4vOg
There were some bloopers during live coding, presentation gods weren't with me today, but I think it's still a decent mark of the #Pongo journey 😉
I just noticed we're one person short of having 100 people on the #Emmett & #Pongo Discord server.
Who wants to be the 100th? 😀
Feel invited! https://discord.com/invite/VzvxR5Rb38
Boom 💣💥 New #Pongo Release with a huge set of changes!
1. New Pongo shell, you can now use REPL without installing Pongo in your project.
2. Optimistic Concurrency handling, no need for Mongo-like retries.
3. You can use custom SQL updates, filtering with useful SQL tagged template literals to cover what's missing in the API,
4. You can now print your queries to the console to track what's happening
5. Added sample using hashtag#CockroachDB and typed client.
As I'm working on adding observability #Emmett and #Pongo, I decided to return to this idea and show how tests can drive predictable observability!
Check the latest #ArchitectureWeekly release to see my take: https://www.architecture-weekly.com/p/making-your-system-observability
As always, feedback is more than welcome!
4/4
In case you missed it, #Pongo got a big release with a new feature set yesterday.
I know that reading release notes may sound boring, so I did a more human-readable write-up, especially for you.
https://event-driven.io/en/pongo_strongly_typed_client/
I covered why getting a strongly typed client with full typing and storage migrations is a big deal in both DevEx and Performance.
p.s. Pongo is like a Mongo but uses Postgres to give you strong consistency and user-friendly API. Check it out
New big 🐶 #Pongo release!
💪 Strongly typed client.
You can define your collections typed schema and benefit from Typescript. It'll automatically generate the collections with provided names and typing.
🖥️ CLI tool
Together with typed schema, enables running database migrations upfront. That helps to get a performance boost, as you can disable automated schema setup (which is good for the dev environment but not for the prod).
See: https://github.com/event-driven-io/Pongo/releases/tag/0.14.0
Regina/Emma : "Pongo!!!!"
Pongo: woof woof woof *Stay way from my humans*
#SwanQueen
#Pongo
#LanaParrilla #ReginaMills #JenniferMorrison #EmmaSwan more #Meg than #Jaws
Client Info
Server: https://mastodon.social
Version: 2025.04
Repository: https://github.com/cyevgeniy/lmst