Video yükleniyor...

Video Yüklenemedi

Ana Sayfaya Dön

The Spring Data Team JDBC framework does not support schema generation yet: But there is a workaround! Use IntelliJ IDEA to generate schema init scripts for Liquibase and Flyway.

14,478 görüntüleme • 6 ay önce •via X (Twitter)

0 Yorum

Yorum bulunmuyor

Orijinal gönderinin yorumları burada görünecek

Benzer Videolar

Today at Yoast we’re shipping something I've actually wanted to see on the web for some time (even before working at Yoast) and am now honored to be part of the team to bring this to the masses... Built in collaboration with the Open Source and NLWeb team at Microsoft lead by R.V.Guha (co-creator of RSS, RDF and other web standards) - we're introducing the Schema Aggregation feature: a "schemamap" endpoint that outputs your site's entire structured data map in one place. ​ Under the hood, we now provide a standardised, deduplicated map of your entities via a single endpoint. An agent no longer needs to crawl all individual pages to understand its meaning but can now ingest an entire entity map with ease. ​ A few details to note about the endpoint: - It's is cacheable with sub‑100ms responses - It respects existing privacy and indexing settings - It aggregates all indexable content without navigation noise - It merges duplicate entities so your "Author X" or "Article Y" exist as a single node instead of being re‑discovered on every URL. - If you're using one of our paid plugins that extends schema even more (such as Yoast WooCommerce SEO adds product schema) this will be populated within the endpoint too - If you already extend Yoast’s Schema API, or use partners like events or recipe plugins, their entities are pulled into the same map automatically. ​ For me, this is one of the first major ways the agentic web can ingest a site at scale, and with much more efficiency and context. It has also been so much fun to work with this alongside the team at Yoast, particularly the genius mind of Alain Schlesser. Lastly, we have also launched a schema visualisation tool to view how everything is output. You can enable this feature today with the free version of Yoast SEO.

Alex Moss

15,372 görüntüleme • 6 ay önce

Big moment for Postgres! AI coding tools have been surprisingly bad at writing Postgres code. Not because the models are dumb, but because of how they learned SQL in the first place. LLMs are trained on the internet, which is full of outdated Stack Overflow answers and quick-fix tutorials. So when you ask an AI to generate a schema, it gives you something that technically runs but misses decades of Postgres evolution, like: - No GENERATED ALWAYS AS IDENTITY (added in PG10) - No expression or partial indexes - No NULLS NOT DISTINCT (PG15) - Missing CHECK constraints and proper foreign keys - Generic naming that tells you nothing But this is actually a solvable problem. You can teach AI tools to write better Postgres by giving them access to the right documentation at inference time. This exact solution is actually implemented in the newly released pg-aiguide by Tiger Data - Creators of TimescaleDB, which is an open-source MCP server that provides coding tools access to 35 years of Postgres expertise. In a gist, the MCP server enables: - Semantic search over the official PostgreSQL manual (version-aware, so it knows PG14 vs PG17 differences) - Curated skills with opinionated best practices for schema design, indexing, and constraints. I ran an experiment with Claude Code to see how well this works, and worked with the team to put this together. Prompt: "Generate a schema for an e-commerce site twice, one with the MCP server disabled, one with it enabled. Finally, run an assessment to compare the generated schemas." The run with the MCP server led to: - 420% more indexes (including partial and expression indexes) - 235% more constraints - 60% more tables (proper normalization) - 11 automation functions and triggers - Modern PG17 patterns throughout The MCP-assisted schema had proper data integrity, performance optimizations baked in, and followed naming conventions that actually make sense in production. pg-aiguide works with Claude Code, Cursor, VS Code, and any MCP-compatible tool. It's free and fully open source. I have shared the repo in the replies!

Avi Chawla

187,076 görüntüleme • 8 ay önce