---
title: "Discussion on \"Why should you not be using BIT or BOOLEAN Flags in MariaDB?\" | Hashnode"
description: "Discussion on \"Why should you not be using BIT or BOOLEAN Flags in MariaDB?\". Avoid MariaDB BIT/BOOLEAN flags for performance, indexing, maintenance, compatibility. Use TINYINT(1) or ENUM('Y', 'N') instead"
url: "https://hashnode.com/posts/why-should-you-not-be-using-bit-or-boolean-flags-in-mariadb/65b169d7d93ca5351067deb5"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Why should you not be using BIT or BOOLEAN Flags in MariaDB?](https://shiviyer.hashnode.dev/why-should-you-not-be-using-bit-or-boolean-flags-in-mariadb?utm_source=hashnode&utm_medium=feed)

Avoid MariaDB BIT/BOOLEAN flags for performance, indexing, maintenance, compatibility. Use TINYINT(1) or ENUM('Y', 'N') instead

Jan 24, 2024 · 2 min read · shiviyer.hashnode.dev  
Read the article

-   [#mariadb](https://hashnode.com/tag/mariadb)
-   [#mysql](https://hashnode.com/tag/mysql)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#dba](https://hashnode.com/tag/dba)
-   [#innodb](https://hashnode.com/tag/innodb)

## Written by

[Shiv Iyer](https://hashnode.com/@shiviyer)

@shiviyer

  
[View profile](https://hashnode.com/@shiviyer)

Founder CEO of #MinervaDB #ChistaDATA #MySQL #PostgreSQL #RocksDB #InnoDB #MariaDB #ClickHouse #MongoDB #Linux #Entreprenuer #Investor #Star

Over two decades of experience as a Database Architect and Database Engineer with core expertize in Database Systems Architecture/Internals, Performance Engineering, Scalability, Distributed Database Systems, SQL Tuning, Index Optimization, Cloud Database Infrastructure Optimization, Disk I/O Optimization, Data Migration and Database Security. I am the founder CEO of MinervaDB Inc. and ChistaDATA Inc.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.