Tag: SQLite

DBeaver tutorial for PostgreSQL, SQLite, MySQL, and MariaDB

Posted on January 19, 2024 by Liquid Web

Category: Tutorials | Tags: Database Management, MariaDB, MySQL, SQLite, Tools

Reading Time: 4 minutes

DBeaver is a complimentary database tool that supports any database having a JDBC driver. Software developers, SQL writers, database administrators, and data analysts leverage its excellent functionality for interacting with databases. This DBeaver tutorial for PostgreSQL, SQLite, MySQL, and MariaDB covers connecting and working with the database platform of your choice in addition to those mentioned.

Continue reading →

Installing SQLAlchemy With Pip

Posted on January 21, 2020 by David Singer | Updated: April 24, 2023

Category: Tutorials | Tags: CentOS, Databases, DBAPI, Developer, Expression, Firebird, Git, Informix, Language, Mapper, mapping, Microsoft SQL, MySQL, object, Oracle, ORM, PIP, PIP3, PostgreSQL, Python, Python 3, Python classes, Python-PIP, Raw SQL, Relational, SQL, SQL Expression Language, SQLAlchemy, SQLite, sqlite3, Sybase, Tables, Toolkit, Ubuntu, utilities, Venv, Virtualenv

Reading Time: 7 minutes

The SQLAlchemy Toolkit and Object Relational Mapper is an extensive set of utilities for working with Python and databases. This toolkit provides a package full of popular persistence patterns, designed for economical and robust database accessibility. SQLAlchemy allows a developer to use simple SQL statements (unlike other Object Relational Mapping tools) which provide a helpful method to connect database tables with user-defined Python classes. The SQLAlchemy Object Relational Mapping tool is primarily centered on using the SQL Expression language.

Continue reading →