Another year passes. I was hoping to write more articles instead of just these end-of-the-year screeds, but I almost died in the spring semester, and it sucked up my time. Nevertheless, I will go ...

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even though we probably won't. For all its popularity and success, SQL is a ...

Parse and validate XML/HTML documents Extract data using XPath expressions Convert between XML, HTML, and JSON formats Read files directly into DuckDB tables ...

IRI NextForm is a helpful migration solution for a variety of data formats and projects. Learn about it here. The data migration process for many organizations is ongoing. Whether you are going ...

Here is a complete guide that will help you to convert KML files to Excel worksheets or CSV format on your Windows 11/10 PC. KML (Keyhole Markup Language) is a GPS data file format used to save ...

The world of data management features many ETL tools and these two are among the best, but which will work better for you? ETL (Extract, Transform and Load) tools and software are powerful information ...

Simple OSM XML data to SQL converter command. This command will create 7 SQL files with foreign key constraints. You can use these SQL files with MySQL/ SQLite or any other SQL server. All tables have ...