Posted in Technology

Poor man’s full text search for SuiteCRM

The poor man’s CRM, a.k.a SuiteCRM …

Posted in Technology

Full-text search using PostgreSQL: simple, fast, cached

Let’s find out what can we achieve; using what we already have, without adding other layers, servers or applications: PostgreSQL. It will help us keep the architecture simple, please be patient 🙂

Posted in Technology

Managing date fields properly with correct time zones in PostgreSQL

In apps for users all around the world (even in apps for local users where DST applies) correct time zones should be set, after database connection is established, based on the user’s time zone setting (rather than hard-coded setting in app). Then, data read/write ops should be automatically handled by the database.

Posted in Technology

Postgresql and Node.js 100% Javascript Adventure – Part 2

This is the second part of PostgreSQL, Node.js and JavaScript post.

Posted in Technology

PostgreSQL and Node.js – 100% JavaScript Adventure

This is a log of every step I will take to create a 100%-JavaScript application back to front.

Posted in Technology

Recursive Relationships in Databases

One of the tricky issues in entity relationship model is the recursive relationships. Sometimes an entity needs to refer to itself.

Posted in Technology

Adaptable Database Design

I had an opportunity to work on a Magento implementation and checked its database. I had heard about its adaptability to almost any online e-commerce business in almost any country. So, I had a chance to see how it is achieved on the database level.

Posted in Technology

Creating a CV indexing facility using Oracle Text

Recently, I have struggled to get Oracle Text working on Linux.

Posted in Technology

Emergency check on command-line for Oracle XE

Go to your Oracle binaries folder and export environment variables, if they are not set already.

Posted in Technology

Show MS Access Subreports With No Data

On MS Access applications, usually I use subreport objects with SQL queries of their own, linked to the main report which includes the subreport. Classic example of such master-detail reports is invoices …