You never develop code without version control, why do you develop your database without it? Flyway is database-independent library for tracking, managing and applying database changes.
(Full Story: Flyaway – a java database migration tool)
Tag Archives: database
NoSQL is a Premature Optimization
July 31, 2011
0 Comments
Point 1: NoSQL technologies require more investment than Relational to get going with.
Point 2: There is no particular advantage to NoSQL until you reach scales that require it. In fact it is the opposite, given Point 1.
Point 3: If you are fortunate enough to need the scaling, you will have the time to migrate to NoSQL and it isn’t that expensive or painful to do so when the time comes.
(Full Story: NoSQL is a Premature Optimization)
Data Structure Visualization
May 17, 2011
1 Comment
visualizations for data structures and algorithms
(Full Story: Data Structure Visualization)
Tips for Tuning MySQL
March 15, 2011
0 Comments
- Innodb parameters – the 4 “Usual Suspects”
- innodb_buffer_pool_size
- innodb_log_buffer_siz
- einnodb_thread_concurrency
- innodb_flush_method
- Bonus #0 – flushing logs at transaction commit
- Bonus #1 – mysql logging
- Bonus #2 – linux ‘swappiness’
- Bonus #3 – my “Virtualization Rant”
(Full Story: Tips for Tuning MySQL)
Base – OSX tool for SQLite
February 23, 2011
0 Comments
Base is an application for creating, designing, editing and browsing SQLite 3 database files. It’s a proper Mac OS X application. Fast to launch, quick to get in to and get the data you need.
(Full Story: Base – OSX tool for SQLite)
