Open-source, self-hosted Arduino, Raspberry Pi, and ESP32 simulator.
https://t.co/8w5RClkdYp
Like the Wokwi project, Velxio simulates popular development boards right in your web browser. But the difference is that the open-source project can be self-hosted, running on your own machine.
The project currently supports 19 boards and 48 components. Other highlights include support for multiple boards (e.g., Arduino connected to ESP32) and full QEMU emulation support for ESP32 and Raspberry Pi 3 (Linux).
🎉 So cool! PostgreSQL 18 can now do Index Skip Scans, meaning that you can now use the Index even when filtering by the second column.
Other worth noting features:
1️⃣ Asyn I/O when scanning pages from the disk
2️⃣ Virtual columns that can be computed at query time (great for JSON path indexing)
3️⃣ Time-sorted UUID via uuidv7()
For more details, check out this article from Crunchy Data.
https://t.co/fiRFEeDFix
congrats to the @PostgreSQL contributors 🐘
◆ asynchronous I/O
◆ UUIDv7
◆ virtual generated columns
◆ temporal constraints
◆ oauth authentication
◆ improved text search
◆ parallel streaming in replication
◆ new wire protocol (first new protocol version since 2003)