360SOFTY

Insights

Engineering Insights

Practical writing on software architecture, SaaS products, AI automation, legacy modernisation, and the business of building reliable systems.

RSS

Curated links from external sources — not 360Softy original articles.

ExternalDatabase
PostgreSQL News

pg_tre 1.1.1 released -- an approximate-REGEX index AM for PostgreSQL 18+

I am pleased to announce the first public release of [pg_tre] (https://codeberg.org/gregburd/pg_tre), a native PostgreSQL 18+ index access method for approximate-regex matching. pg_tre indexes text columns through a three-tier filter funnel (BRIN-style range bloom -> sparsemap trigram postings -> per-tuple bloom) backed by Ville Laurikari's TRE library for the heap recheck. The result is genuine Levenshtein-distance regex matching ("find text within k edits of this pattern") driven through a rea

PostgreSQL NewsRead original
ExternalDatabase
PostgreSQL News

pg_infer 1.0.0 released -- transformer model knowledge as SQL relations

I am pleased to announce the first public release of pg_infer, a PostgreSQL 18+ extension that exposes the internals of small transformer language models -- gate activations, feature labels, learned associations, embeddings -- as SQL-queryable relations and a custom index access method. pg_infer is not "natural language to SQL." It is not "SQL to natural language." There is no chat interface, no agent loop, no prompt template generating queries. pg_infer brings model inference into the query pla

PostgreSQL NewsRead original
ExternalDatabase
PostgreSQL News

pg_mentat 1.3.0 released -- Datomic-compatible Datalog inside PostgreSQL

I am pleased to announce the first public release of [pg_mentat] (https://github.com/gburd/pg_mentat), a PostgreSQL extension that implements Datomic's data model -- immutable facts (datoms), schema-first attributes, a full Datalog query compiler, the pull API, time travel, and ACID transactions -- entirely inside PostgreSQL. pg_mentat is built with pgrx 0.17 in Rust and supports PostgreSQL 13 through 18. The current release is 1.3.0, the "Postgres Extension Family" release, which adds Datalog w

PostgreSQL NewsRead original
ExternalSoftware Engineering
GitHub Changelog

GitHub Copilot for Eclipse is open source

Following our previous updates, GitHub Copilot for Eclipse is open source, with the code available on GitHub under the MIT license. This marks an important milestone for GitHub Copilot in… The post GitHub Copilot for Eclipse is open source appeared first on The GitHub Blog.

GitHub ChangelogRead original
ExternalSoftware Engineering
DEV Community

I built a search engine over 1,600+ cybersecurity articles — here's what I actually learned

A year ago I had a problem: 1,600+ cybersecurity articles spread across a Go backend, and a search bar that returned garbage. The standard MySQL LIKE '%keyword%' approach was embarrassing. Searching "pentest Active Directory" returned articles that happened to contain the word "pentest" on one side and "Directory" somewhere else — totally unrelated content ranked first. So I rebuilt it from scratch. Here's the honest version of what happened. My backend is Go Fiber. I needed something that: Hand

aimeilisearchwebdev
DEV CommunityRead original
ExternalSoftware Engineering
DEV Community

I used LLMs to rewrite meta descriptions for 1,600 articles — honest results

Meta descriptions are the most underrated SEO element on content-heavy sites. They don't affect rankings directly, but they determine whether someone clicks your result in Google. A bad meta description on a well-ranked article is traffic you're leaving on the table. I had 1,600+ cybersecurity articles. About 40% had no meta description at all. Another 30% had descriptions that were either truncated, keyword-stuffed, or copy-pasted from the first paragraph (which almost never makes a good descri

aiseowebdev
DEV CommunityRead original
ExternalSoftware Engineering
DEV Community

Per-user cost attribution for your AI APP

You ship your AI feature. It works. A week later your OpenAI bill is $400 and you have no idea which of your users caused which $0.05. This is the single most underrated metric in production LLM apps — cost per end-user — and it's surprisingly easy to instrument if you know what to do. Here are the three approaches I've found work in practice, ranked by setup time. Works for Express, Next.js Route Handlers, Fastify — anything that has a single OpenAI or Anthropic client instance. import OpenAI f

aisaasopensource
DEV CommunityRead original

Work with 360Softy

Building a SaaS product, AI system, or business platform?

Book a free consultation and we will tell you honestly whether we can help.

Book a consultationView our services →