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
Switch from DbDesigner to SQL Power Architect and convert ERD
For several years I’ve been using DbDesigner for data modeling but DbDesigner is dead project and is not handling big models properly. Lately I’ve switched to SQL Power Architect – it’s open source, written in Java, so I’ve made some improvements and modifications (see bottom). Converting ERD is possible in two steps: first reverse engineering … Continue reading
vi – users manual (or my favorite subset of vi commands)
Abstract vi is a very old text editor but is still useful as it is available in every Linux/Unix and also included in Cygwin under Windows. Each person uses another subset of vi commands and considers them as most useful and efficient way of using this editor. Below you will find my favorite subset of … Continue reading
National characters in PDF base fonts using Apache™ FOP
The problem The solution Solving the problem with Apache™ FOP How to use it – jump here if you just need a solution The problem Many countries use basic Latin alphabet enhanced with some extra characters. For example in Poland we use 9 extra characters, each one in capital and small version, which makes … 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