Search Results for "tables"

pg-osc (Online Schema Change) is a CLI tool for making non-blocking schema changes to large PostgreSQL tables. It creates a shadow table, copies data incrementally, and swaps tables with minimal downtime. Ideal for high-traffic applications, pg-osc lets teams modify database structures safely in production environments.

Blazer is a business-intelligence engine for Rails that lets teams write SQL in the browser, visualize the results, and share insights without leaving their app. It turns raw database queries into charts, tables, and dashboards, so non-engineers can explore data with minimal friction. Queries can accept parameters, enabling reusable reports for different time ranges, segments, or customers. Access controls and audit trails help teams manage who can run, edit, or view sensitive analyses. Scheduled checks and alerts turn BI into proactive monitoring by notifying you when metrics cross thresholds or regress. ...

Logidze is a Ruby on Rails extension that enables versioning for ActiveRecord models using PostgreSQL JSONB columns. It stores change history directly in the database, allowing applications to track, view, and restore previous states of a record without creating additional tables. Unlike traditional audit systems, Logidze is lightweight and fast, leveraging PostgreSQL’s capabilities for efficient data storage and retrieval.

HIPAATalk - Contains stored procedures and sample DTS packages for parsing and converting X12 to flat tables and creating HIPAA-compliant X12 files. Currently reads 820, 834, 835, 837P/I/D, 841, 997, TA1, and creates 835, 837P/I/D, 834, 277U, 997, TA1.

LabDiary is a program for managing laboratory experiments in a sophisticated way. It is very easy to use - you can link experiments logically with each other, associate files to an experiment and structure all your data.

REMO == Remo Edits Makello Online: you can -- either with a web browser or a face-to-face Ruby application -- define SQL tables, links & indexes. REMO turns this into the framework of an application to manage the data (first sales data, so Makello).