tables Archives

AppWizard

June 12, 2026

Telegram’s Wear OS app makes a comeback, now with full chats, voice notes, and more

Telegram has reintroduced its app to Wear OS, allowing Android smartwatch users to access a fully functional messaging interface. The new version enables users to scroll through complete conversations, view photos, videos, and location previews, and play voice messages directly from the smartwatch. Users can actively engage in conversations by replying with text or voice, sending stickers, and managing chats. On the smartphone side, Telegram has enhanced its Android app with features such as bots that send richly formatted messages and manage group interactions. Group administrators can assign bots for moderation, and Telegram Polls now support clickable links. The in-app browser has been improved to handle links more flexibly, allowing users to customize how links open.

AppWizard

June 12, 2026

Retro Arcade Shop Simulator Brings the Neon 80s to PC

The Retro Arcade Shop Simulator, developed by Alt Tab Game, will debut on PC with a demo available on June 11. The full version is expected in 2026/2027, with a console release in 2027. The game allows players to build and manage their own retro arcade, featuring 28 types of entertainment options and interactive machines. The demo includes four progression levels, six types of attractions, and customization options for layout and decor. Players can manage a cafeteria and hire staff. The minimum system requirements for the PC demo include Windows 10 (64-bit), Intel Core i3-14100F or AMD Ryzen 5 5560U, 8 GB RAM, NVIDIA GeForce GTX 1060 or AMD Radeon RX 5600, and 8 GB of available SSD space.

Tech Optimizer

June 10, 2026

Microsoft Open-Sources PostgreSQL Extension for In-Database Durable Execution

Microsoft has introduced pg_durable, a PostgreSQL extension that enables developers to execute durable workflows within the database, reducing the need for external orchestration systems. It simplifies workflow management by allowing developers to express long-running, fault-tolerant SQL functions directly in SQL, managing execution concerns like retries and recovery. Workflows are defined in SQL, with the extension handling retry states, progress tracking, and checkpointing. A pg_durable function operates as a graph of SQL steps that can resume from the last durable checkpoint after a failure. The extension preserves execution states within PostgreSQL tables, ensuring workflows can withstand crashes and restarts. It includes a domain-specific language (DSL) for scheduling and parallel execution. An example of a durable function is provided, demonstrating sequential and parallel execution using specific operators. pg_durable is particularly useful for vector embedding pipelines and scheduled maintenance tasks. Architecturally, it consists of a PostgreSQL extension and a background worker built on Rust libraries, without any external control plane. Durable execution allows long-running workflows to automatically resume from failure points, simplifying distributed system architecture.

Tech Optimizer

June 6, 2026

PostgreSQL Dump and Restore: The Complete pg_dump Guide

pg_dump is a utility for exporting a PostgreSQL database into a file, which can be restored on the same or different servers. It exports a single database's tables, views, sequences, functions, indexes, triggers, and in-database grants but does not include roles, tablespaces, or server-level configurations. To capture global objects, pg_dumpall --globals-only should be executed prior to the per-database dump. pg_dump requires CONNECT and SELECT privileges on all tables and sequences within the target database, and a dedicated backup role is sufficient for single-database dumps, while superuser access is needed for global objects. pg_dump supports various output formats: plain SQL (.sql), custom binary (.dump), directory of files, and tar archive (.tar), each with different capabilities for restoration and compression. The custom format allows for selective and parallel restoration. For non-interactive use, credentials can be stored in a .pgpass file or passed via the PGPASSWORD environment variable. Restoration methods depend on the dump format: psql is used for plain SQL files, while pg_restore is used for custom and directory formats. The restoration process requires the target database to be created beforehand. Version mismatches between pg_dump and pg_restore can lead to failures, so it's essential to ensure that the binaries are version-matched. In Docker, pg_dump and pg_restore can be executed within containers, but care must be taken to manage credentials and ensure version compatibility. Exit codes from pg_dump should be checked to confirm successful operations.

Tech Optimizer

June 6, 2026

PostgreSQL vs SQL Server 2026: $0 vs $15K License

PostgreSQL has become the most utilized database for developers for two consecutive years as of 2026, while SQL Server has introduced native AI capabilities and vector search functionalities in its latest release. PostgreSQL is favored for new projects due to its permissive licensing, cross-platform operation, and extensive ecosystem of extensions, whereas SQL Server is preferred by organizations already using Microsoft products for its robust tooling and enterprise support. As of June 2026, SQL Server ranks third in the DB-Engines popularity ranking with a score of 698, while PostgreSQL ranks fourth with a score of 688. Developer adoption trends show that 49% of respondents in the Stack Overflow 2024 Developer Survey use PostgreSQL, compared to 27% for SQL Server. The latest stable version of PostgreSQL is 18.4, released on May 14, 2026, while SQL Server 2025 (version 17.x) became generally available on November 18, 2025. PostgreSQL is free under a permissive license, while SQL Server's Enterprise Edition can cost upwards of ,123 per two-core pack, with an eight-core minimum. PostgreSQL supports various operating systems, including Linux, Windows, macOS, and BSD, while SQL Server operates on Windows and Linux. PostgreSQL uses PL/pgSQL as its primary procedural language, allowing for multiple procedural languages, whereas SQL Server uses T-SQL. PostgreSQL's JSONB type offers rich indexing, while SQL Server added native JSON support in its 2025 release. Both databases are capable of handling high transaction volumes, but PostgreSQL excels in read-heavy scenarios due to its multi-version concurrency control, while SQL Server's columnstore indexes provide advantages for analytical workloads. PostgreSQL supports tables up to 32 TB, while SQL Server can handle a maximum database size of 524 PB. SQL Server's high availability technology includes Always On Availability Groups, while PostgreSQL offers built-in streaming and logical replication. The security features of both databases meet enterprise standards, with PostgreSQL providing a transparent patching process and SQL Server integrating with Microsoft tools. Real-world usage examples include Stack Overflow using SQL Server, while Instagram and Reddit utilize PostgreSQL. Developer sentiment increasingly favors PostgreSQL for new projects, emphasizing flexibility and open-source solutions. For new startups or greenfield projects, PostgreSQL is recommended due to its zero license cost and compatibility. Existing Microsoft enterprises are advised to stick with SQL Server for its integration benefits. Migration from SQL Server to PostgreSQL is becoming common, with a structured approach required for successful transitions.

Tech Optimizer

June 4, 2026

EDB adds quorum commit to distributed Postgres 6.4

EDB has released version 6.4 of its Postgres Distributed (PGD) solution, which includes enhancements such as quorum commit, native connection pooling, and support for PostgreSQL large objects. The quorum commit feature ensures a unified transaction outcome across cluster nodes before finalizing a transaction, addressing potential risks from conflicting writes in distributed systems. This update targets organizations in sectors like banking, payments, telecommunications, and infrastructure, aiming to provide the same consistency guarantees previously reliant on proprietary databases. The Connection Manager now includes native connection pooling, reducing the need for external connection poolers and streamlining operations by integrating with PGD's Raft consensus layer. This integration allows for automatic route adjustments during failover and improved monitoring capabilities. Additionally, the update expands replication support to include PostgreSQL large objects, enhancing the applicability of distributed Postgres for managing mixed data sets in sectors like government, healthcare, and financial services. EDB also noted a Gartner forecast that by 2030, over 75% of enterprises in Europe and the Middle East will have repatriated workloads to their home jurisdictions, emphasizing the importance of consistent data management across locations. EDB aims to strengthen Postgres's position in the market by focusing on transaction integrity in distributed environments while minimizing reliance on additional infrastructure components.

Tech Optimizer

June 2, 2026

10 GitHub Repositories for Modern Database Systems and Tools

Databases have evolved from merely storing application records to supporting real-time analytics, embedded SQL, caching, monitoring, replication, AI agent memory, and comprehensive application backends. Numerous open-source GitHub repositories have emerged, allowing developers to experiment with and deploy self-managed servers. 1. ClickHouse: A real-time analytics database management system for fast analytical queries on large datasets, ideal for dashboards and business intelligence workloads. 2. DuckDB: An in-process analytical SQL database designed for local environments, suitable for data scientists and analysts needing rapid SQL-based analytics. 3. Supabase: A Postgres development platform offering a dedicated Postgres database and tools for authentication, APIs, and storage, popular for web and mobile applications. 4. Redis: A high-speed in-memory data store for caching, real-time applications, and session storage, known for its exceptional performance and support for various data structures. 5. Prometheus: A monitoring system and time series database for collecting and querying metrics, essential for observability in production systems. 6. Vitess: A database clustering system for horizontally scaling MySQL, addressing sharding, routing, and replication challenges for large deployments. 7. LiteFS: A FUSE-based file system for replicating SQLite databases across clusters, extending SQLite's capabilities into distributed environments. 8. OpenViking: An open-source context database for AI agents, managing memory and resources through a file system-like structure. 9. pgAdmin: An open-source administration platform for PostgreSQL, providing a graphical interface for managing databases and writing queries. 10. Adminer: A lightweight database management tool in a single PHP file, offering simple deployment and administration for various database systems. The modern database ecosystem is crucial for building reliable, real-time web applications, with tools like ClickHouse and DuckDB excelling in analytics, while Supabase and Redis enhance application development. Prometheus, Vitess, and LiteFS address monitoring, scaling, and replication needs, and OpenViking supports AI applications. Starting with DuckDB, Supabase, and Redis is recommended for beginners, while exploring ClickHouse, Prometheus, Vitess, and pgAdmin is beneficial for production systems.

Tech Optimizer

May 28, 2026

EDB Releases PGD 6.4 with Quorum Commit, Bringing True Distributed Consistency to Mission-Critical Postgres

EnterpriseDB (EDB) has released EDB Postgres Distributed (PGD) 6.4, featuring three key enhancements: Quorum Commit for cross-node consistency, integrated connection pooling via the native Connection Manager, and full replication support for PostgreSQL large objects. Quorum Commit ensures that all nodes in a cluster reach consensus before committing transactions, addressing issues with traditional replication. The integrated Connection Manager simplifies operations by eliminating the need for external pooling solutions and providing cluster-aware routing and automatic failover. The support for large objects allows for the management of diverse data types within a single database environment. PGD 6.4 is available as a stand-alone distribution and will be integrated into EDB Postgres AI in June.

Tech Optimizer

May 28, 2026

Graph Queries Across Billions of Rows of Scattered Data with Postgres and Apache AGE™

Postgres engines can now connect to large data repositories using extensions like pg_lake, allowing access to files in object storage formats such as CSV, JSON, Apache Parquet™, and Apache Iceberg™. The Apache AGE™ extension enhances data usability through graph relationships, enabling complex queries that require both graph traversal and analytical aggregation. Apache AGE introduces openCypher graph query support within Postgres, allowing for integration without data movement, as both Iceberg tables and graphs reside in the same database. This integration facilitates the construction of graphs from lake tables, allows for combining SQL and Cypher queries, and simplifies operational processes by consolidating application connection, security, and backups into a single workflow. An example of this integration is a healthcare platform using Iceberg tables on Amazon S3, which includes various data types such as claims, providers, patients, and referrals. To utilize these features, necessary Postgres extensions must be loaded, with pg_lake operating alongside a sidecar, the pgduck_server, for Iceberg operations.

Winsage

May 26, 2026

Windows’ classic 3D Space Cadet pinball is getting a physical re-creation

3D Pinball for Windows – Space Cadet was included with several Microsoft operating systems until Windows XP and was part of the Full Tilt! Pinball software collection launched by Maxis in 1995. Deeproot Pinball attempted to create a physical version of Space Cadet but faced collapse before completion. Hobbyist CNCDan is now working on a physical Space Cadet table, featuring 3D-printed mechanical flippers, pop bumpers with embedded LEDs, slingshots, and a raised playfield. He has encountered challenges with the size and positioning of table elements, resulting in a playfield that measures 56 cm in width, which is smaller than typical commercial pinball tables.