PostgreSQL, also known as Postgres, is a popular open-source relational database management system (RDBMS) that is widely used by developers and organizations around the world. FreeBSD, a free and open-source operating system, is well-known for its …

Synchronize a model from a live database to Enterprise Architect.

1. Select your database from the Database Model folder in Project Browser.
2. Go to Tools > Database Builder
3. Right click on Tables > Show Differences. We can also click on a different …

This Java example finds all the tables and their corresponding columns from a database. The code iterates over the entities and columns found and shows them on the console.

Minor changes are necessary to process the found values in a different way. …

This post will be updated with snippets for Oracle. I hope you find it useful.

1. Change the default date format

Most useful snippet of the year! 😉

1ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY HH24:MI:SS';
2select sysdate from dual;

2. …

This time we are going to create a basic connection to MySQL in Java and pull some data from it.

// Compile it:
// javac Mysql.java
//
// Try it:
// java -classpath mysql-connector-java-5.1.27-bin.jar:. MySQL

import java.sql.Connection;
import …

Installing PHP/MongoDB extension is a two steps task on OSX:

• Install the autoconf tool required for compiling the extension
• Install the Mongo extension

You have to install autoconf in order to avoid the following error:

1Cannot find autoconf. …

This time I want to share a 1000 rows SQL table that you can use for text searches. It includes a table with 1 column, 1000 rows song title names. It is plain standard SQL so you can use it with any database manager.

Download it here.

Hope you find …

This morning I got a new surprise from my Exchange server. Outlook clients could not connect to the servers, however the server seemed to be working pretty normal. After some research I found out the Exchange databases were corrupted. But, how did …