Dear smartwatch designers!

Please, change. Use e-ink for display and automatic quartz for power supply. Don’t duplicate functionality of smartphone. That’s all, thank you!

SQL Power Architect improvements

I’m using SQL Power Architect for over a year. This is one of the best open source CASE tools for ERD modeling. However it needs some improvements especially in PostgreSQL support. I’ve made several changes and sent my contribution to Power Architect team – they plan to review it in January 2016. You may test my changes as well. … Continue reading

Patch and compile SQL Power Architect

This post explains how to compile SQL Power Architect from sources with my modifications, described in another article. You need: Java version 1.7 (may be version 8 is ok, but I haven’t tested it) and Eclipse with Git plugin. Mind that version of Git plugin must match version of Eclipse – you can install incompatible versions and you won’t get … Continue reading

Polskie znaczki

Polskie znaczki w różnych kodowaniach Ą ą Ż ż Ź ź Ś ś Ę ę Ć ć Ń ń Ó ó Ł ł 1250 165 185 175 191 143 159 140 156 202 234 198 230 209 241 211 243 163 179 iso8859-2 161 177 175 191 172 188 166 182 202 234 198 230 … Continue reading

Convert Progress RDBMS to PostgreSQL

Introduction Progress RDBMS [1] is a commercial database, PostgreSQL [2] is an open-source product. To use this mechanism you need to know how to connect to Progress database and execute a procedure. It might require – so called – xcoding and compiling, so you should have some practice with Progress. My solution uses PostgreSQL COPY … Continue reading

DBDesigner and PostgreSQL

This is an old instruction, written in 2009. Now I’m using SQL Power Architect for my data modeling. This document provides a step by step instruction how to use DBDesigner along with PostgreSQL. I’ve modified XSLs provided by Thomas – member of DBDesigner’s forum, then these files were finally improved by Maciej Blizinski. I’m using … Continue reading

DbasePsql – Convert .dbf files into PostgreSQL

This document provides a step by step instruction how to convert DBase II, DBase III+, DBase IV and (to some extent) FoxProV2 files to PostgreSQL. Update! New version extended and modified by Sebastian Baumhekel is described below. This solution is based on excellent Simple DBase SQL by Michael Lecuyer. I used version 2.03 – check … Continue reading