Monday, September 07. 2009Database Administration, Reporting, and Light application developmentPrinter FriendlyRecommended Books: Database Design, Application Development, and Administration PostgreSQL (2nd Edition) - Douglas PostgreSQL 8.4 Server Administration
Comments
Display comments as
(Linear | Threaded)
One of my favorite tools is Aqua Datastudio. It supports all of the databases I use on a daily basis; runs on Mac, Linux and Window; logs all of your queries; and is fairly feature complete. If it did code completion for Oracle packages, it would be the only tool I'd use.
http://www.aquafold.com/
#1
on
2009-09-02 21:01
Database Master is my favorit. It is a awesome tool and awesome user friendly. I can visualize relations, import csv,sql files. But most important is editing and reporting data (inluding blob fields).
Great Tool and thank you for this great product ;-) http://www.nucleonsoftware.com
#1.1
on
2009-09-04 17:09
Nice writeup!
One tool that I use a lot is DbVisualizer. It supports several database engines using JDBC and runs on Linux, Mac, Unix and Windows. There is a free version and the paid for version is reasonably priced. http://www.dbvis.com
#2
on
2009-09-02 22:51
Don't forget the huge Java ecosystem of Open Source database and Business Intelligence tools that work over JDBC so database compatibility is excellent. Just a few examples:
SquirrelSQL, a SQL browser and frontend: http://squirrel-sql.sourceforge.net/ Power*Architect for database design (includes forward and reverse engineering), with special support for special database dialects including Postgres: http://www.sqlpower.ca/page/architect Everything from Pentaho (e.g. data integration, reporting, OLAP): http://community.pentaho.com/ Those are the ones I use on a daily basis. I seldom need other tools.
#3
on
2009-09-03 01:00
Thanks all for the feedback. We'll add these to the list.
#4
on
2009-09-03 01:31
FYI - pgAdmin III includes an excellent PL/pgSQL debugger.
#5
on
2009-09-03 08:13
I just linked your great guide into the less well maintained page covering this on the PG wiki: http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
#6
on
2009-09-03 17:36
Thanks Greg
#6.1
on
2009-09-03 22:48
You might want to consider SQL Workbench/J as well, which has strong export/import capabilities, schema diff, data diff and can be used in batch files as well.
Thomas,
Thanks for the heads up. We've added to our list. I really love the light-weight slick interface, sql formatter and the data pump. I'll have to play with the data pump some more since its something I can forsee using a lot and I really love the way you have implemented the screen. So far been impressed.
#7.1
on
2009-09-07 01:59
Any chance you could change "commercial," to "proprietary" where appropriate? FLOSS has been used in commerce for some decades now.
Done
#8.1
on
2009-09-03 22:03
You missed out Servoy. http://www.servoy.com - (It's proprietary, but not sure on latest prices - should be on the website somewhere.)
I use it regularly as a RAD environment (it's simple enough that I can use it) and it works well with Postgres.
#9
on
2009-11-13 04:46
Many IDE's also provide full service SQL connections using driver as well. Currently I am using NetBeans for development and NetBeans to connect to PostGres. Provides nice graphical output, and editing. The kicker for me- code completion! (the thing I've been missing most from my Toad days). For serious DBA stuff you will still need something else, but for casual edits, minor schema changes and queries, it's nice to have.
#10
on
2010-01-10 04:48
For table structure/data comparison Zidsoft CompareData http://www.zidsoft.com is a performance, ODBC-based database comparison tools that supports PostgreSQL (free for comparing table/view data).
For diffing two different schemas and generating upgrade SQL statements, there is application called Another PostgreSQL Diff Tool.
It is already quite advanced, all the details about the application can be found at its homepage at http://apgdiff.startnet.biz/ I think it might be good addition to the list of applications.
I think Another PostgreSQL Diff Tool (also known as apgdiff, homepage http://apgdiff.startnet.biz/) could be added on the list too. It makes PostgreSQL database schema upgrades much easier.
Im use WaveaMaker with PosgreSQL and have nice web app and complex too...tryit www.wavemaker.com a nice RAD also can build your own datamodel like Posgres pgadmin client,...
dbSchema is the best!
Basically has everything I need and the best ER modeler in my opinion.
#15
on
2011-07-03 12:58
Also would like to mention Datanamic's postgresql data and schema comparer. More info at: http://www.datanamic.com/schemadiff-for-postgresql/index.html
DtSQL is also a good universal database tool to support a lot of databases including PostgreSQL. It could be found at http://www.dtsql.com
|
Entry's LinksQuicksearchCalendar
Categories
Blog Administration |
A while ago we demonstrated how to use Open Office Base to connect to a PostgreSQL server using both the native PostgreSQL SBC and the PostgreSQL JDBC driver. The routine for doing the same in Open Office Base 3.2 is pretty much the same as it was in the
Tracked: Jun 28, 02:31