A practical week: tips to get more out of the database, a cross-platform mobile tool that became free and a TypeScript framework to put AI agents into production.
Little-known techniques to speed up PostgreSQL queries
Haki Benita gathered creative PostgreSQL optimizations beyond the classic adding an index. One example: with the constraint_exclusion setting on, the database uses check constraints to avoid scanning the whole table when a condition can never be true, such as a typo in a report filter. The article also shows function-based indexes for low-cardinality columns and hash indexes, through exclusion constraints, to enforce uniqueness.
Performance gains are often in fine-tuning the database, without changing infrastructure or buying a bigger machine. A review of the most expensive queries and of the indexes usually cuts cloud costs and response times.
How Dexpert helps: Backend & APIsSources
- Haki Benita: Unconventional PostgreSQL Optimizations
Skip, which builds native Android apps from Swift, becomes free and open source
Skip, a tool for building iOS and Android apps from a single Swift and SwiftUI codebase, is now completely free and open source. Before, businesses needed a paid subscription. According to the team, the change answers the expectation that developer tools are free and companies' concern about depending on a small company's closed-source tool.
Teams that already have an iOS app in Swift get a license-free path to Android with a native interface. Compare it with Flutter and React Native, considering the existing code and the team you have.
How Dexpert helps: Mobile AppsSources
Mastra reaches 1.0 as a TypeScript framework for AI agents
Mastra, an open source framework built by the Gatsby team, reached version 1.0. It connects to more than 40 model providers through one interface and offers agents, workflows with explicit control flow, pauses for human approval, memory and MCP server authoring. It can be embedded in React, Next.js and Node apps or run as a standalone server.
For companies with a JavaScript stack, a mature framework shortens the path from an agent prototype to production, with human approval and model switching without rewriting code. It is a good base for internal assistants and AI automations.
How Dexpert helps: Artificial IntelligenceWant to put one of these to work in your company?
Dexpert builds custom systems, apps, integrations and AI solutions. Tell us what you need and get an estimate, or take the free digital maturity assessment.