ProgerHub
4.86K subscribers
137 photos
2 videos
64 files
301 links
Ads & contact: @crazydev93

A channel with programming news and tips and tricks, nice for beginners but also for experienced programmers. πŸ’»
Download Telegram
DuckDB is a high-performance analytical database system. It is designed to be fast, reliable, portable, and easy to use. DuckDB provides a rich SQL dialect with support far beyond basic SQL. DuckDB supports arbitrary and nested correlated subqueries, window functions, collations, complex types (arrays, structs, maps), and several extensions designed to make SQL easier to use.

https://github.com/duckdb/duckdb
Forwarded from Programming Books
LLMs in Production: From language models to successful products - Brousseau Christopher

Author: Sharp Matt
Year: 2025

Download
Floci is a free, open-source local AWS emulator for development, testing, and CI.

It gives you AWS-shaped services on your machine without requiring a cloud account, an auth token, or paid feature gates. Point your AWS SDK, CLI, Terraform, CDK, OpenTofu, or test suite at http://localhost:4566 and keep your existing workflows.

https://github.com/floci-io/floci
Things Every Engineer Should Know: SQL Execution Order.

Source
Two ways to keep a user logged in.

And they fail in very different ways.

After login, you need to remember who the user is.

There's typically two common approaches:
β€’ Session token: a random ID. The server stores the session and looks it up each request.
β€’ JWT: a signed token holding the user's info. The server just verifies the signature, no lookup.

JWTs scale well because there's no server-side storage. That's also their weakness.

This is because you can't easily revoke a JWT before it expires. A logged-out user's token still works until it times out. Sessions you can kill instantly.

The solution, which is still not ideal, for JWTs is short expiration and token blacklisting.

Stateless is convenient, but "can't revoke" is a real security tradeoff.

Source
gevent is a coroutine-based Python networking library that uses greenlet to provide a high-level synchronous API on top of the libev or libuv event loop.

https://www.gevent.org/api/gevent.greenlet.html
Media is too big
VIEW IN TELEGRAM
Redis Pub/Sub vs Kafka

Source
This media is not supported in your browser
VIEW IN TELEGRAM
IRIS is a shell auto-completion tool that works like code editor's IntelliSense

Github
❀1
The #1 Open-Source CRM

- TypeScript
- Nx
- NestJS, with BullMQ, PostgreSQL, Redis
- React, with Jotai, Linaria and Lingui

https://github.com/twentyhq/twenty
❀3
πŸ‘2
❀5πŸ‘4