~betterdevlink | Bookmarks (106)

pgxman package manager for PostgreSQL extensions, along with a repository of packages. It integrates with native build systems for installation.

wedges An ever-expanding, open-source React UI library built with the Wedges Design System, Radix primitives, and Tailwind CSS.

go mysql server A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.

litellm Call all LLM APIs using the OpenAI format. Use Bedrock, Azure, OpenAI, Cohere, Anthropic, Ollama, Sagemaker, HuggingFace, Replicate (100+ LLMs)

Building a GPS Receiver, Part 1: Hearing Whispers I know zero thing about GPS receiver. And I may not build this after reading this article, but my knowledge indeed improve on this topic. I understand more about the technology that we use day to day

How two processes can communicate in one device using IPC Simple way we can use shared file, you can use a client <-> server, but that involve you are need to setup port, sending and serializing data. What if you want your processes to be independent, to communicate, and yet not distribute some arcane shell scripts along with them? It turns out that other...

Building a weather data warehouse: Loading a trillion rows of weather data into TimescaleDB Challenge of building a data warehouse. How to load a massive amount of data quickly,

DNS tcpdump by example analyze traffic of DNS is a easier and fun practice because it has no encryption, unlike HTTPS or SSH. So you can actually look at the payload. In this article we will walk through th exercise to analyze this traffic of querying a DNS end to end, what happen, where do they get their data. Knowing this knowledge will put...

Slack Journey Migrating to AWS IMDSv2 Have you ever query 169.254.169.254 you deal with AWS IDMS service. Anyone can query that from an EC2 instance. In 2019, they release IMDSv2, which require a token so it’s more secure. Slack running 60,000 AWS instance. How can they roll this out safely across the fleet of services on all these 60,000 server to use IDMSv2

Profile Node.js performance with the Performance panel The JS Profiler is going away in Chrome 124, so we would need to familiar ourself with the newer approach.

Calculus made easy With all the trend about LLM, maybe time to dust up our math skill in high school.

Rebuilding Tables online using pg_repack in PostgreSQL Any database engine, including PostgreSQL, requires some routine maintenance to ensure optimal performance. Especially when there are massive delete or purge operations to delete rows from a Table, the fragmentation builds up within a table. Reclaim this fragmented space from disk requires a table to be rebuilt

hyperformula an open-source headless spreadsheet for business web apps. It comes with over 400 formulas, CRUD operations, undo-redo, clipboard support, and sorting. Built in TypeScript, supported by the Handsontable Team

validates_email_format_of Validate e-mail addreses against RFC 2822 and RFC 3696 with this Ruby on Rails plugin and gem.

Open Sora Plan This project aim to reproduce Sora (Open AI T2V model), they wish the open source community contribute to this project.

trdsql CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.

Setting up PostgreSQL for running integration tests I’ll explain how to set up PostgreSQL for tests and discuss some common pitfalls to avoid.

Object structure in JavaScript engines Love it or hate it. We will stick with JavaScript for quite a long time. Understanding these objects and its memory lay out is a must to improve your performance optimization skill

A simple query with a big problem Render.com staging pipeline got blocked due to what looked like a simple query SELECT e.id FROM events e JOIN postgres_dbs db ON (e.data ->> ‘serviceId’) = db.database_id LIMIT 1; Can you spot what’s wrong? Let’s read