Skip to main content

Database

Database Normalization: Scratching the Database Surface

·7 mins
Introduction # Database normalization is the process of structuring a database, in accordance with a series of normal forms in order to reduce data redundancy and improve integrity. In other words, database normalization is basically breaking a table into two to prevent repetitive columns aka data redundancy. It entails organizing the columns (attributes) and tables (relations) of a database to ensure that their dependencies are properly enforced by database integrity constraints. It is accomplished by applying some formal rules either by a process of synthesis (creating a new database design) or decomposition (improving an existing database design).

Introduction to BoltDB

Why use BoltDB # Bolt plays pretty well with Go’s concurrency model, we can do multiple reads concurrently. For pro and cons, I will contrast it with similar database SQLite. I have done SQLite when I worked with Xentrix to develop GUI tools for the artists. You may want to connect with me on LinkedIn. Pro # It is native go. This means you don’t need any database server running, like SQLite. In oppose to Redis and memcached.