Querying CSV and Parquet exports inside a SQL IDE with DuckDB

·2 views

Someone sends you a CSV export and asks you to investigate it. You need to check duplicates, group records, or compare it with another export. For a one-off analysis, loading it into a database or writing a separate script can take longer than the query itself. I'm building omni-sql, an open-source SQL IDE with embedded DuckDB. You can import CSV or Parquet and query it with SQL inside the IDE.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Mejores gadgets con inteligencia artificial dispositivos útiles

Mejores gadgets con inteligencia artificial y dispositivos útiles son conceptos que por fin coinciden tras dos años de fiascos comerciales ruidosos. Por ejemplo, el intento fallido de sustituir al teléfono móvil mediante broches magnéticos que proyectaban rayos láser sobre la piel o cajitas naranjas con ruedas mecánicas terminó en cancelaciones corporativas y cajones llenos de polvo. Quienes compran tecnología en la actualidad buscan periféricos especializados que resuelvan fricciones concretas. Por ejemplo: capturar reuniones sin tomar apuntes, traducir carteles en tiempo real sin sacar el te

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Run, Hunt, Hack: Join the Cloud Run Hackathon on Product Hunt

Got a cool side project running on your local machine? This is your chance to make it live and have the chance to win cool prizes while you do it with the Google Cloud Run Hackathon on Product Hunt on Wednesday, October 14th. Never used Cloud Run before? It’s easy! Simply deploy your project with one simple command, and let Cloud Run handle all of the infrastructure for you, automatically scaling based on how much traffic your app is getting.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Introducing Nugetz.dev — We Built a Better Way to Search NuGet

Last month I shipped Nugetz.dev. It’s a modern interface for searching the NuGet registry. This isn’t a startup launch. It’s not a product pivot. It’s not a monetization play.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

What I Wish I Knew Before I Started My Programming Journey

All the things I'll say in this post are based on my past experiences with beginners (including myself). The information I display is not applicable to every beginner, nor is it applicable to only beginners. There are a lot of types of people beginning to code. The one I'm targeting is the 'ambitious' developer. This person wants to create massive and complex projects, even when they just started coding.

0 comments Read more at DEV Community