Articles tagged: Database
Follow Database
They land in your feed reader on their own — no account, no email address, nothing to unsubscribe from. Paste this URL into your reader:
https://www.avonture.be/blog/tags/database/rss.xmlNo feed reader yet? Start here — it takes two minutes.
DuckDB - Query JSON and CSV Files With SQL, No Database Required →
Run real SQL — joins, window functions, GROUP BY — directly against JSON and CSV files, no import step, no server, no schema to define. Dockerized, with a duckdb shell function that works from any folder. The tool I reach for once awk or jq stop being enough.
November 9, 2026
Export MS Access objects →
Easily version control your MS Access database! Export all VBA code, forms, modules, queries, and reports to flat files using a simple VBS script for GitHub integration.
June 27, 2025
Discovering Pentaho, an ETL program →
Discover Pentaho Data Integration (ETL). Follow this step-by-step guide to install Pentaho (PDI/Kettle) on Linux and load data from an Excel file into a PostgreSQL database using Docker.
June 20, 2025
MS Excel - Connect to a SQL Server database, run a query and get the results - Step by step →
Connect MS Excel VBA to SQL Server with this step-by-step tutorial. Learn to run SQL queries, retrieve data, and output results into your spreadsheet. Docker setup included.
March 16, 2025
Drawdb-app - Render your database model as png, markdown, mermaid, ... →
Easily visualize and document your database model with DrawDB-app. Import SQL files, generate diagrams, and export to PNG, Markdown, Mermaid, and more.
November 11, 2024
Start Joomla with Docker in just a few clicks →
Start your Joomla website with Docker in just a few clicks! Follow this quick, right-to-the-point guide to launch your Joomla project instantly using a simple Docker Compose setup.
October 3, 2024
SQL - Formatting tool →
Easily clean up unreadable, legacy SQL code with a simple formatting tool. Make your SQL queries instantly readable and kickstart your code review process.
July 17, 2024
Joomla - Run a SQL statement outside Joomla and display a nice HTML table →
Easily export live Joomla data to Microsoft Excel. Learn to run a custom SQL query outside of Joomla and display the results in a refreshable HTML table for spreadsheet linking.
June 2, 2024
MS Excel - Connect to a SQL Server database, run a query and get the results →
Connect MS Excel to SQL Server with VBA. Run SQL queries, inject results directly into your spreadsheet, and preserve formatting. Learn the best method for data refresh or secure sharing.
April 5, 2024
How to optimize an existing MS Access database →
Speed up your slow Microsoft Access database with this step-by-step optimization guide. Learn to improve table structure, use indexes, optimize queries, and compact your database for better performance.
March 9, 2024
VBS - Retrieve the list of fields in a MS Access Database →
Use a VBScript to easily retrieve a detailed list of fields from your MS Access database. Analyze field size, type, and actual value length to optimize your database structure.
March 9, 2024
Joomla - delete tables from your database according to a certain prefix →
Clean up your Joomla database by easily deleting unwanted tables using a specific prefix. Follow this step-by-step guide to use a simple PHP utility safely.
February 28, 2024
Don't query your PostgreSQL db anymore, prefer PostgREST →
Use Docker and PostgREST to instantly turn your PostgreSQL database into a powerful RESTful API. Eliminate SQL queries and complex database models from your application code with this simple setup tutorial.
January 6, 2024
Play with Microsoft SQL Server 2022 using Docker →
Easily run MSSQL Server 2022 using Docker. This step-by-step guide shows you how to install the container, connect with SSMS, and start querying your database.
January 5, 2024
Using Adminer, pgadmin or phpmyadmin to access your Docker database container →
Use Adminer, pgadmin, or phpmyadmin to access your Docker database container. Get the simple command-line instructions for MySQL, MariaDB, and PostgreSQL.
December 27, 2023