Category: Database
-
Reindexing PostgreSQL Databases with reindexdb utility
As a developer using a PostgreSQL RDS database instance on AWS, I needed to reindex my database on RDS to improve query performance. I logged into one of my EC2 instances and used the reindexdb utility to rebuild the indexes on my RDS database. In this post, I’ll explain how to use the key options…
-
Building an HL7 Database in SQLite for HIPAA-Compliant Local Disease/Medical Archive with a Windows Application
Storing and managing medical data securely and efficiently is crucial in the healthcare industry. HL7 (Health Level Seven) serves as a widely used standard for exchanging healthcare information electronically, while SQLite, a lightweight and embeddable relational database management system (RDBMS), offers a suitable platform for local storage and organization. This article delves into creating a…