What is SQLAlchemy?Python has many libraries to connect to SQL databases. SQLAlchemy is a Python SQL toolkit that allows developers […] November 12, 2024 in Python tagged data / database / python / SQLAlchemy by Mike
Import CSV to SQLiteWith DB Browser we can import a comma separated values (CSV) file into a SQLite database file. Using […] November 10, 2024 in Database tagged csv / sqlite / database / file / import by Mike
DBeaver DatabaseDBeaver is a SQL client software application and a database administration tool for relational databases. DBeaver Community is […] May 15, 2024 in Database tagged data / database / dataset by Mike
Data ArchitectureWhat is data architecture? It’s not a simple task to define data architecture, partly because the field is […] September 12, 2023 in Data Engineering tagged design / architecture / data / database by Mike
PostgreSQL IntroductionPostgreSQL is a very popular open-source database platform. The homepage says: “PostgreSQL is a powerful, open source object-relational […] July 23, 2023 in Database tagged data / database by Mike
Chinook DatabaseThe Chinook Database is a sample database available for several database products, including SQL Server, PostgreSQL, MySQL, Oracle, […] January 10, 2023 in Database tagged digital / media / music / sample / dataset / data / database by Mike
Data Model Examples in ExcelDo you want to work with a few small & sample data models in Excel to practice the […] December 13, 2022 in Database tagged database / excel / sample / model / relationship / dataset / bridge / data by Mike
Internet Movie Database (IMDB)The Internet Movie Database (IMDB.com) is a large website containing information related to films, television programs, home videos, […] November 12, 2021 in IMDB tagged database / internet / dataset / movie / imdb / tv / IMDB Data Files by Mike
Daily Thought Back-EndIn this third post on this project we’ll look at the back-end, meaning the database. The database technology […] November 25, 2020 in WPF tagged back / end / database / sql / table / sqlite / daily / thought / WPF Daily Thought by Mike
SQLite IntroductionWikipedia says: “SQLite is a relational database management system (RDBMS) contained in a C library. In contrast to […] November 11, 2020 in Database tagged database / sql / sqlite / local / SQLite by Mike
WPF SQLite ToDo CRUD SQLiteIn this part we discuss the database. It’s a SQLite database. We need to create a SQLite database […] May 20, 2020 in WPF tagged no / such / database / error / table / Dapper / sqlite / WPF SQLite ToDo CRUD by Mike
WPF SQLite Dapper List and Add People – 1This series of posts shows us how to build a WPF project using SQLite and Dapper that allows […] May 6, 2020 in Dapper tagged sqlite / people / database / sql / WPF / Dapper / WPF SQLite Dapper People by Mike