Exploring how to write python dict/key-value pairs and a table-like structure to a CSV file.

Introduction

LibSQL is an Open Contribution fork of SQLite. Open Contribution means that it allows suggestions and contributions from the community as opposed to SQLite which is open source but doesn’t accept community contributions.

Installation of LibSQL Client(s)

There are two libraries for LibSQL to interact with Python, the libsql-client and the libsql-experimental-python. The former is the recommended client as it is stable, whereas the latter is in development and has the latest features from the libsql database engine, however, it is compatible with the sqlite module.

Django + HTMX Chat application

Introduction

In this article, we will be creating a Django project, which will be a chat-room kind of application. The user needs to authenticate to the app and then and there he/she can create or join rooms, every room will have some name and URL associated with it. So, the user simply needs to enter the name of the room, which will be unique. The user can then simply enter the messages in the chat room. This is a core chat application that uses web sockets.

Understanding how to add a non-clustered index in a postgres database in a django project.

Using bulk_update to update multiple objects in one go.

Exploring the pipreqs package that allows to list all the dependencies or packages which are imported in a python project

Introduction

Have you ever used the Postgres database and did you know you don’t have to launch PGAdmin every time you want to write SQL queries, you can write down those queries even inside a terminal with a python package. It’s PGCLI, that can act as an editor window for writing SQL queries for Postgres Databases. We can simply execute SQL queries in a PSQL-like shell with additional features like autocompletion, text-editing modes, file input/output options, etc.

Generate ER Diagram for your Django project in Markdown with Mermaid

Get the list of all the models and associated fields/attributes in a django project or an application

Rendering frontatter from content field into the Template Form field using HTMX and frontmatter libraries