Our preferred way of testing ActiveRecord is to simply create/update/destroy the record and then check if the expected behavior has...

makandra dev

Geordi is now (partially) tested with Cucumber. Yay! geordi cucumber supports a new @solo tag. Scenarios tagged with @solo...

github.com

Using Scenic, you can bring the power of SQL views to your Rails application without having to switch your schema...

makandra dev

Ever wondered how you can create a simple table output in bash? You can use the tool column for creating...

SELECT pg_database.datname as "database_name", pg_database_size(pg_database.datname)/1024/1024 AS size_in_mb FROM pg_database ORDER...

postgresql.org

PostgreSQL offers a really handy field type: json. You can store any JSON there, in any structure. While its flexibility...

nateberkopec.com

rack-mini-profiler is a powerful Swiss army knife for Rack app performance. Measure SQL queries, memory allocation and CPU...

If you have many connections to your MySQL or MariaDB (as we have) you might want to filter the list...

I recommend to go straight to 2.1.5+ without intermediate steps. Otherwhise you burden yourself with unnecessary work of encoding problems...

keycdn.com

Table of contents of the linked article: What are Web Fonts? Advantages of Web Fonts Disadvantages of Web Fonts

postgresql.org

PostgreSQL's array data type is pretty useful, but manipulating values of arrays can be awkward because of its syntax...

Our applications not only need to be functional, they need to be fast. But, to quote Donald Knuth, premature optimization...

postgresonline.com

When working with PostgreSQL, you can use pgAdmin as a GUI. While you can do most things just like on...

It smells. Rethink your code design. Code example with makandra/has_defaults: class Post < ActiveRecord::Base has_defaults tags: [] # field in db...

If you need a postgresql extension for your database it isn't a good idea to give your applications database...

Use form models to handle this problem Or soften the validation to validates_presence_of :parent

In tests, it is sometimes useful to create records with specific ids. On PostgreSQL this can cause problems: Usually, PostgreSQL...

The migration DSL now supports adding and removing foreign keys. They are dumped to schema.rb as well. At this time...

iPads will not trigger click events for all elements. You can fix that, but you don't want to know...

Large projects usually have large test suites that can run for a long time. This can be annoying as running...

When using ORDER BY "column" in PostgreSQL, NULL values will come last. When using ORDER BY "column" DESC, NULLs will...

postgresql.org

There is no such thing as a "default order" of rows in database tables. For instance, when you paginate a...

forum.openoffice.org

If you're a frequent user of LibreOffice, I strongly recommend to checkout out the VLOOKUP function (SVERWEIS in German...

makandra dev
nexts.github.io

Small (1.5 KB) Javascript library that lets you render tables, lists, etc. with hundreds of thousands of items.