PostBooks from xTuple is a fully-integrated ERP, RM, and accounting system for small to midsized businesses. It uses a Qt interface and runs on several platforms, including Linux, Windows, and Mac.
Postbooks includes the following modules:
- Accounting (general ledger, accounts receivable and payable, bank reconciliation, financial reporting)
- Sales (quotes, order entry, sales reporting, shipping)
- CRM (universal address book, incident management, opportunity management, to-do lists, project management)
- Purchasing (purchase orders, receiving, vendor reporting)
- Product Definition (items, infinite-level bills of material)
- Inventory (multiple locations, other advanced warehouse features)
- Light Manufacturing (work orders, strong support for make-to-order)
- OpenRPT open source report writer
PostgreSQL hasn’t had much coverage on this site yet and that’s something we’re going to correct now. PostgreSQL has, for the longest time, had a running rivalry with MySQL as the great open source database. MySQL has arguably been more popular but PostgreSQL is not without its share of advocates and adherents.
In this short article, we’re going to take a quick look at two tools written for designing and administering PostrgreSQL databases. These were selected for their recent releases this April.
First up, we have pgDesigner, an open source program for graphic design of PostgreSQL databases. pgDesigner is written in Gambas, a Visual BASIC-like programming language and requires Gambas to run. pgDesigner is currently at version 1.2.3.
Next, we have phpPgAdmin, a web-based administration tool for PostgreSQL databases. phpPgAdmin can administer multiple servers and is ideal for managing remote databases. Almost all aspects of a running PostgreSQL database can be managed using phpPgAdmin. phpPgAdmin is currently at version 4.2.
MyJSQLView is a Java based GUI frontend for viewing, adding, editing, or deleting data in the MySQL, PostgreSQL, and HSQL databases. A query tool allows the building of complex SELECT SQL statements. The application allows sorting, searching, and import/export of table data.
Version 2.87 was just released recently.
