PrecisionSQLHow to Prevent Partition Pruning From Failing Silently
Wrong partition key can scan every partition.
YouTube
How to Prevent UTF8MB4 From Truncating Indexes
Long utf8mb4 keys can exceed index limits.
How to Prevent UTF8MB4 From Truncating Indexes #index
Jack Linke π¦These models are used in literally thousands of places in the project - they're truly the heart of the system. And this weekend I am attempting a major heart surgery to rewire them.
This includes standard migrations, data migrations, and lots and lots of refactoring throughout the project.
Terrifying stuff.
Wish me luck π¬
3/3
N-gated Hacker Newsπ Woohoo! Another #Ruby #gem promising to make #Excel docs β¨beautifulβ¨ without needing a PhD in ECMA specs. Because clearly, the world cries out for more "stylish" #spreadsheets that come with the added excitement of #schema validation! π§π
https://github.com/caxlsx/caxlsx #Stylish #Validation #Developer #Tools #HackerNews #ngated
https://github.com/caxlsx/caxlsx #Stylish #Validation #Developer #Tools #HackerNews #ngated
GitHub - caxlsx/caxlsx: xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine.
xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents...
Hacker NewsRelax NG is a schema language for XML
#HackerNews #RelaxNG #XML #Schema #Language #XML #Schema #Design #Data #Validation
Cap PuckhaberCap Puckhaber from Black Diamond Marketing in Reno, Nevada breaks down schema aggregation. Learn how to win rich snippets, master the agentic web, and use a schema to boost your SERP: https://cappuckhaber.com/schema-aggregation-and-visualization-guide/
#SEO #Schema #AI #Marketing #LLM
#SEO #Schema #AI #Marketing #LLM
Lisa DeBruineCrossref is great for journal articles, and datacite is great for datasets and software. Bibtex is good for citations, but not as detailed.
I really tried to avoid it, but I've been forced into creating a 15th standard to rule them all :(
Let me know if there's something I've missed. #schema
robrichWant to #automate #deploy #DB #Schema changes? Join us for "#Database #DevOps #Pipeline" at #ConFoo starting soon in St Laurent 3. https://confoo.ca/en/2026/session/a-database-devops-pipeline Slides: https://robrich.org/slides/database-devops-pipeline/, code: https://github.com/robrich/database-devops-pipeline
Claudio PiresHow To Use 'How To' Schema in WordPress? Ste-by-Step SEO Tutorial ππ» https://www.youtube.com/watch?v=AuHT1iJQ53g π¬ #Schema #HowTo #WordPress #SEO #Guide
