open-source technology Archives

Tech Optimizer

January 27, 2026

PostgreSQL for WMS: a DBMS selection strategy in the era of import substitution

Choosing a Database Management System (DBMS) for Warehouse Management Systems (WMS) is a strategic decision that impacts security, budget, and adaptability. PostgreSQL is identified as a safe, cost-effective, and future-proof solution for Russian warehouse systems, especially following the withdrawal of foreign vendors like Oracle and Microsoft SQL Server. Starting September 1, 2025, foreign software usage in government bodies and companies with over 50% state ownership will face legal restrictions, posing regulatory risks for those using Oracle. Financial risks include high licensing fees and the potential for legal prohibitions on current technologies. Business continuity risks arise from the possibility of vendors ceasing support and updates. PostgreSQL, both in its vanilla form and commercial derivatives like Postgres Pro, is presented as a robust alternative capable of handling high loads and providing necessary features for modern WMS. It supports real-time analytics and advanced capabilities such as intelligent search and automatic classification using neural networks. Key considerations when choosing a DBMS include estimating data volumes, checking legal requirements, and calculating total cost of ownership (TCO).

Tech Optimizer

December 12, 2025

Interweb, Inc. Rebrands as Constructive™ — A Unified, Modular, and Secure Postgres Platform for Production-Grade Applications

Interweb, Inc. has rebranded as Constructive™ as of March 2020, consolidating its projects, LaunchQL and Hyperweb, into a unified Postgres platform. The platform emphasizes strong security and modular architecture, supporting Row-Level Security (RLS) patterns and providing end-to-end testing tools. Constructive features an integrated testing stack built on the pgsql-test engine, allowing teams to validate permissions and enhance reliability in development. Key offerings include modular PostgreSQL building blocks, secure-by-design workflows, and AI-native specification-driven development. The Constructive team has contributed to open-source technology, achieving over 90 million npm downloads and supporting thousands of developers globally.

AppWizard

November 11, 2025

German healthcare aims to replace faxes and phones with secure mess…

Germany's healthcare system is introducing TI-Messenger, an encrypted messaging service overseen by Germany’s National Digital Health Agency, Gematik, to enhance communication among patients, healthcare professionals, and insurance companies. This service aims to replace traditional communication methods like faxes and phone calls, with initial trials showing significant time savings for medical staff. TI-Messenger, based on the Matrix open network technology standard, is designed to allow secure communication across health institutions while maintaining data control. As of July 15, 2025, it became accessible to all German citizens with public health insurance. A trial in Hamburg demonstrated that pharmacists significantly reduced phone calls by using TI-Messenger. There are two versions of the service: TI Messenger ePA for citizens and TI-Messenger Pro for healthcare professionals, which has not yet seen widespread adoption. Challenges in user adoption exist, with potential solutions including financial incentives and simplified onboarding processes. Future developments may lead to automated responses and improved communication practices, with hopes for collaboration with other European countries using similar technologies.

Tech Optimizer

October 8, 2025

How OpenAI scaled with Azure Database for PostgreSQL – Microsoft for Startups Blog

OpenAI utilizes PostgreSQL as the backbone for its essential systems, particularly in collaboration with Microsoft Azure Database for PostgreSQL. Initially, OpenAI adopted a straightforward architecture with a single primary Postgres instance for write operations and multiple read-only replicas for handling read traffic. This setup allowed for exceptional scalability in read operations, but as demand increased, write requests became a bottleneck. To address scalability challenges, OpenAI implemented several strategies, including offloading write workloads, optimizing read-heavy workloads with replicas and smart query routing, and establishing schema governance for stability. These optimizations led to significant outcomes: the PostgreSQL cluster now processes millions of queries per second, has numerous global read replicas for low-latency access, and has improved database response times from approximately 50 milliseconds to under five milliseconds for many queries. OpenAI's collaboration with Azure Database for PostgreSQL facilitated ease of scaling and replication, allowing for the seamless addition of replicas and the development of features like elastic clusters and cascading read replicas. The advantages of Azure included high availability, co-innovation support, and security compliance, providing a reliable foundation for OpenAI's optimizations.

AppWizard

October 7, 2025

Google Japan turns typing into dialing with its wild Gboard rotary keyboard

Google Japan has introduced the Gboard Dial Version, a keyboard that uses nine spinning dials instead of traditional keys, allowing users to "dial" each letter. This device is part of a series of unconventional Gboard concepts and is completely open-source, with all design files, schematics, and firmware available on GitHub under the Apache 2.0 license. Users can construct their own version of the keyboard, which promotes a deliberate typing method that may reduce the risk of repetitive strain injuries. While it may not be practical for everyday use, it serves as a playful exploration of engineering and a commentary on digital interactions. The design includes options for various aesthetics and features a small accessory stand that acts as a control for video calls.

Tech Optimizer

October 6, 2025

Supabase Raises $100 Million to Power Enterprise AI Databases

Supabase has secured 0 million in Series E funding, co-led by Accel and Peak XV, raising its valuation to billion. The company offers Multigres, an AI-optimized version of PostgreSQL, and pgvector, a Postgres extension for embedding support. Supabase's user base has grown from 2 million to over 4 million developers, with more than 100,000 customers. The team includes Sugu Sougoumarane, co-creator of Vitess, and other notable contributors. Supabase emphasizes open source and community investment, allocating part of its funding for this purpose. The upcoming Multigres expansion aims to enhance performance for both small and large applications.

Tech Optimizer

October 4, 2025

Supabase Secures $100M to Scale its PostgreSQL AI Database

Supabase has raised 0 million in a Series E funding round, valuing the company at billion. The funding aims to enhance its PostgreSQL AI database capabilities, particularly with the introduction of Multigres, an enterprise-scale solution. Supabase's advanced version of PostgreSQL integrates the open-source pgvector tool for efficient handling of AI model embeddings. The platform also features Edge Functions for serverless functions in JavaScript and collaborates with Hugging Face to process embeddings. Supabase's developer base has doubled from 2 million to over 4 million recently. The funding will support technological advancements, particularly in developing Multigres, led by Sugu Sougoumarane, co-creator of Vitess.

Tech Optimizer

October 4, 2025

PostgreSQL specialist Supabase snags $100M in funding

Supabase has secured 0 million in late-stage funding, led by Accel and Peak XV, raising its valuation to billion. The company now has over 4 million developers using its platform, up from 2 million in April. Supabase offers a customized version of PostgreSQL with enhanced features for AI developers, including support for embeddings through the open-source tool pgvector. The platform also includes Edge Functions for serverless functions and has introduced a branching tool for database management. With the new funding, Supabase plans to develop an enterprise-scale version of its platform, Multigres, with assistance from Sugu Sougoumarane, co-creator of Vitess. The company will continue allowing employees to sell 25% of their vested stock during funding rounds and is accelerating hiring for open-source projects. Additionally, Supabase plans to raise another million for early customers and contributors to its open-source platform.

Tech Optimizer

October 4, 2025

PostgreSQL database specialist Supabase snags $100M in funding

Supabase has secured 0 million in late-stage funding to develop a new database tool called Multigres, increasing its valuation to billion. The Series E funding round was led by Accel and Peak XV, following a previous funding round in April where Supabase raised million and reported over 2 million developers in its community, which has now grown to over 4 million. Supabase enhances PostgreSQL with cybersecurity features and tools for AI developers, including support for embeddings through the integration of an open-source tool called pgvector. The company also offers Edge Functions for serverless functions in JavaScript and plans to develop an enterprise-scale version of its platform. Supabase will continue allowing employees to sell 25% of their vested stock in funding rounds and is accelerating hiring for key open-source projects. The company aims to raise an additional 0 million in the future for early customers and contributors to its open-source platform.

AppWizard

July 13, 2025

Secure Messaging: The Guardian Leverages Millions of Readers to Provide Strong Plausible Deniability

The Guardian has introduced a tool called Secure Messaging to protect journalistic sources, utilizing an open-source technology named CoverDrop. This system allows whistleblowers to communicate securely and anonymously with journalists by concealing the fact that messaging is occurring. CoverDrop integrates a module within The Guardian's mobile app, an untrusted cloud-based API, on-premises services known as CoverNode, and a desktop application for journalists. The CoverNode functions as a mix node to ensure the anonymity of sources. The app exchanges encrypted messages that appear indistinguishable from regular app data, providing cover for users. The technology has been rolled out to millions of users this year, and a white paper detailing its design has been published. Currently, the platform does not allow sharing of photographs or documents, but future plans include linking uploaded files with conversations. The source code for CoverDrop is available on GitHub under the Apache License 2.0.