ChatDB Blog
Writings about data, file formats, and AI
New GeoJSON and Shapefile Viewer
Easily preview, explore, and share GeoJSON and Shapefile data right in your browser—no installs or sign‑ups needed.
Screenshot Background Creator: A Simple Tool for Better Visuals
Create professional-looking screenshots easily with our free online gradient background tool. Perfect for presentations, social media, and more.
The Ins and Outs of Image Compression
Everything you need to know about image compression techniques and their impact on file sizes
PNG vs JPG: What's the Difference?
Discover the key differences between PNG and JPG formats and learn how to choose the best option for your web projects. Optimize performance and visual quality.
What Are ICO Images? A Deep Dive into Favicon Files
Explore the world of ICO images, their importance in web design, and how to create and implement them effectively for your website's favicon.
WebP vs PNG: Optimizing Images for Web Performance
Explore the pros and cons of WebP and PNG formats to boost your website's speed and visual quality. Learn when to use each format for optimal results.
How to Make CSV Files Smaller with GZIP Compression
Learn how to compress CSV files to make them smaller and more efficient.
New Image Conversion Tools: Fast, Free, and Browser-Based
Convert images online for free with our new browser-based tools. Support for PNG, JPEG, WebP, GIF, BMP, TIFF, and more.
Columnar Storage in Parquet
Columnar storage in Parquet: Why it's a game changer.
Parquet vs Avro vs Arrow File Formats
Parquet vs Avro vs Arrow: When to use each format.
Pro Tips for Working with Parquet Files
Tips, Tricks, and Techniques for making the most of Parquet Files
Why CSV is King
Why CSV is King: Areas where it excels
Why Parquet is King
Why Parquet is King: when to use it over CSV
Benefits of Storing Parquet Files in S3
Reasons why Parquet is meant for the cloud
Converting a 10GB Parquet File to CSV and JSON
200M rows later, 10GB Parquet to CSV and JSON
Converting a 177M-row CSV to Parquet: A Deep Dive
Explore the power of ChatDB Pro in handling massive datasets, with insights on performance, compression, and data management best practices.
What's Coming to ChatDB
Where we are going and what to expect. Doubling down on building tools for analyzing, converting, and visualizing data from different formats.
CSV vs Parquet
Explore the differences between CSV and Parquet file formats for data storage and analysis.
CSV AI: Querying CSV files with AI and natural language
We are proud to introduce a new, free tool where you can query your CSV with AI.
Introducing ChatDB Dashboards
We are proud to announce charts and MySQL support!
Benchmarking NaturalSQL against State of the Art LLMs
Achieving state of the art results on SQL generation for compound questions.
Introducing NaturalSQL 6.7B
NaturalSQL, a 6.7B open source LLM finetuned on Text to SQL instructions.
Posthog <> ChatDB
Learn how to analyze your product using Posthog and ChatDB together.
Introducing Revamped Charts
Create data visualizations in a couple clicks! Upgrading charting capabilities and the brand new toolbar in ChatDB!
WebGPU + WebLLM: Running LLMs in the Browser
The state of open source LLMs, running them in the browser and WebGPU
OpenAI Dev Day Updates
Explore the different types of SQL joins and learn how they can improve your data analysis capabilities.
Reduce SQL pains with AI 2 SQL Tools
Tackling the toughest aspects of SQL doesn't have to be daunting with AI 2 SQL.
Text 2 SQL AI for Your Database
Explore how you can go from text to sql and query your database in seconds
Analyzing Your Customer's Data with ChatDB
Analyze your customer's data with no SQL required.
Querying the LA Crime Database with GPT-4
Getting insights and answer questions from your data without SQL.
Creating a Read-Only User Account in PostgreSQL
A comprehensive guide on how to create a read-only user account in a PostgreSQL database.
SQL and Single-Use Plastics: An Unlikely Comparison
Drawing a parallel between SQL queries and single-use plastics, exploring how businesses often overlook the recurring value of SQL and how AI can bridge this gap.
DuckDB: An Introduction and Common Use Cases
A comprehensive guide to DuckDB, an in-memory analytical database, and its common use cases.
Ways you can optimize SQL Queries
Discover how to optimize your SQL queries for more efficient data retrieval, reducing system load and improving query performance.
Understanding SQL Joins
Explore the different types of SQL joins and learn how they can improve your data analysis capabilities.
How Database Triggers Work
A deep dive into the world of database triggers. Learn how they work, when to use them, and how they can enhance your database management skills.
The Vision for an AI Database Client
Where we want to take ChatDb and what an AI database looks like
Introducing a Browser-Based SQL Query Console for CSV Files
ChatDB now offers a convenient, browser-based SQL query console for your CSV files.
How AI can reduce onboarding for engineers
Discover how ChatDB uses AI to transform the onboarding process for new engineers, leading to significant cost savings and improved productivity.
Building a More Intuitive AI for Your Database
A deeper dive into the development and potential of our AI-powered database assistant, ChatDB
Why are we building AI for your database?
A letter from the Founder. Why you need an AI database assistant in your business