Sessions are an important part of any HTTP-based web framework. They allow web servers to keep track of the identities of repeat HTTP clients without requiring them to re-authenticate for each request. There are several different ways to keep track of sessions. Some do not require the server to persist session data (like JSON Web Tokens), while others do.

Django, a popular Python-based web framework, ships with a default session backend that does store persistent session data. There are several storage and caching options; you can elect to simply store sessions in the SQL database and look them up each…

Table of Contents

• Introduction
• Acknowledging Risk
• Understanding the principal of low hanging fruit
• Creating a security policy
• Server Security
• Email attackers
• User Roles and Permissions
• Data Sanitizing
• Request Throttling
• Physical Security to Augment Digital Steps
• Self Reflection

Get the Checklist here!

Introduction

Hi, my name is Kirk. I’m a full stack software developer working on the .NET ecosystem and managing a large SQL Server database. I wrote this post to try to answer some of my own questions about what modern database security in 2021 looks like, especially if you’re in the tech field and looking into creating or supporting your…

Django’s versatility makes it the ideal framework for developers endeavoring to collect website analytics, which can then be visualized and analyzed using Arctype’s dashboard functionality — truly a perfect synergy.

Introduction

As Python’s premier web framework, Django provides the foundation upon which many web applications have been built, facilitating rapid development without sacrificing stability. Amongst other versatile functionalities, Django integrates seamlessly with SQL databases, so today, we’ll be using the framework to implement basic site analytics data recording. Then, we’ll use this data to create gorgeous visualizations in an Arctype dashboard, which will keep track of the following:

• Registrations, logins, and…

To explore SQLite along with Python, which is a user-friendly and no-nonsense language, we are going to build a simple tic-tac-toe game. So buckle up and get your machines ready!

Introduction to SQLite and Embedded Databases

SQLite is a small, self-contained, client/embedded database written in the C Programming language and can be summarized using the following points:

• Application library.
• Directly writes to disk.
• Cross-platform, stable, and the most widely deployed and used database engine.
• Zero configuration.
• Automatic recovery.
• Public domain license.

In this article, we are going to see many of these features in action. Features such as data replication, network access, etc., are intentionally absent…

Postgres offers set operators that make it easy to query and filter the results of searches from your database. Set operators are used to join the results of two or more SELECT statements. These operators are UNION, UNION ALL, INTERSECT, and EXCEPT — each can be used to construct queries across multiple tables and filter for the specific data that you need.

To return the combined results of two SELECT statements, we use the UNION set operator. This operator removes all the duplicates from the queried results — only listing one row for each duplicated result. To examine this behavior…

Gartner predicts that by 2023, over 50% of medium to large enterprises will have adopted a Low-code/No-code application as part of their platform development.

The proliferation of Low-code/No-code tooling can be partially attributed to the COVID-19 pandemic, which has put pressure on businesses around the world to rapidly implement digital solutions. However, adoption of these tools — while indeed accelerated by the pandemic — would have occurred either way.

Even before the pandemic, the largest, richest companies had already formed an oligopsony around the best tech talent and most advanced development tools. Low-Code/No-code, therefore, is an attractive solution for small…

The NULL value is a data type that represents an unknown value. It is not equivalent to empty string or zero. Suppose you have an employee table containing columns such as EmployeeId, Name, ContactNumber and an alternate contact number. This table has a few mandatory value columns like EmployeeId, Name, and ContactNumber. However, an alternate contact number is not required and therefore has an unknown value. Therefore a NULL value in this table represents missing or inadequate information. Here are other meanings NULL can have:

• Value Unknown
• Value not available
• Attribute not applicable

In this post we will consider how…

Understanding the PostgreSQL query plan is a critical skill set for developers and database administrators alike. It is probably the first thing we would look at to start optimizing a query, and also the first thing to verify and validate if our optimized query is indeed optimized the way we expect it to be.

Anatomy of a PostgreSQL Query Plan

Before we attempt to read a query plan, it is important to ask some very basic questions:

• Why do we even need a query plan?
• What exactly is represented in the plan?
• Is PostgreSQL not smart enough to optimize my queries automatically? …