Dev tools · September 28, 2022
I wrote a database engine in TypeScript
Hi! I wanted to understand more about databases' internals so I wrote one from scratch. It has a T-SQL inspired syntax with support for functions and procedures. It can be used stand-alone as a SQL engine or with a server allowing for persistence and replication to other connected clients. Performance are nothing near sqlite of course but that's beside the point. It’s a small database engine that can run in a web app as a way to store session data, do small calculations on a web worker, store the document/data the user is editing or facilitate “multiplayer” feature by broadcasting the…
What it does
In the maker’s words, at launch
Hi! I wanted to understand more about databases' internals so I wrote one from scratch. It has a T-SQL inspired syntax with support for functions and procedures. It can be used stand-alone as a SQL engine or with a server allowing for persistence and replication to other connected clients. Performance are nothing near sqlite of course but that's beside the point. It’s a small database engine that can run in a web app as a way to store session data, do small calculations on a web worker, store the document/data the user is editing or facilitate “multiplayer” feature by broadcasting the queries the web app is running. The server runs in a container for that specific document and shutdowns automatically after a set amount of minutes of inactivity. Why did I spend time on this? I am self taught and have been a software developer for about 20 years; moved to the UK for about 10 years, now in Spain and I'm still looking for the place I want to call home. My lack of diploma has never been an issue in Europe but if I want to discover other horizons, having one makes things easier. There's a process in France call "Validation des acquis" (Validation of knowledge) which allows anybody at whatever level to present to a panel of professionals and academics a request to validate one experience and deliver a diploma. That diploma is completely equivalent to a diploma delivered from a university. The experience must validate all of the targeted diploma curriculum so I thought digging into databases will help with that... alex at ixai.net. I'm also looking for a remote position as a Senior software developer
Does the same job
all alternatives →- OFORM for TypeScript with no query-builder, supporting full SQL queries2020 · github.com · ▲220
- PTPgTyped – Typesafe SQL in TypeScript and Postgres2020 · github.com · ▲269
- NONous – Open-Source Agent Framework with Autonomous, SWE Agents, WebUI2024 · github.com · ▲155
Hello HN! The day has finally come to stop adding features and start sharing what I've been building the last 5-6 months. It's a bit of CrewAI, OpenDevon, LangFuse/Cloud all in one, providing devs who prefer TypeScript an integrated framework thats provides a lot out of the box to start experimenting and building agents with. It started after peeking at the LangChain docs a few times and never liking the example code. I began experimenting with automating a simple Jira request from the engineering team to add an index to one of our Google Spanner databases (for context I'm the…
- KBKretes – Build full-stack applications in TypeScript and PostgreSQL2020 · kretes.dev · ▲81
- DADjango Admin for TypeScript2023 · demo.subzero.cloud · ▲5
This demo is build with subZero [0] - The TypeScript library to build internal tools fast Everything is running in JS (express+react-admin), there are no external dependencies (other supporting services), which makes for an easy deployment (single container/service) to any platform that can run JavaScript. The demo uses SQLite as the db but PostgreSQL/MySQL/ClickHouse are also supported. [0] https://getsubzero.today/
- SAStorex – A modular and portable database abstraction for JavaScript2019 · ▲52
We'd like to show you Storex, a database abstraction layer that allows you to move your database interaction code between client- and server-side. By surrounding it with modular, recombinable packages for common problems such as schema migrations, it's possible to re-use logic touching the database across a wide variety of databases, allowing you to develop your code entirely in-browser in your daily development workflow, and then move your database to PostgreSQL/MySQL back-end once you're ready. Storex was designed modularly enough to easily be adapted to mBaaS like Firebase, which is…
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 1d ago · opentrailpaper.com
Launched alongside, September 2022
the whole month →- IM
Life & fun · 2022 · dogbunnypuzzle.com
- IM
A couple of years ago, I had an interesting idea. What if there was a marketplace where all the underlying tech was open-source? The order management system, the storefront, customer support, etc. The marketplace would simply connect to the seller’s infra instead of locking them in. If, for some reason, the seller is removed from the marketplace, their software stays with them and they can continue accepting orders directly. This model can be used to disrupt any marketplace from AirBNB to UberEats: building tech for home renters and restaurants and later, leveraging that to build a competing…
Dev tools · 2022 · openship.org
