Questions tagged [postgresql]

If your question is explicitly for the PostgreSQL database (server or client). Targeting "any" database, rather use the 'database' tag.

Filter by
Sorted by
Tagged with
5
votes
3answers
402 views

A light-weight library to expose SQL database tables over HTTP with querying?

Would you be able to recommend a simple open-source library/tool to run in Linux, which would serve a REST-like API basically serving the content of SQL databases (in Postgres) over HTTP with friendly ...
2
votes
2answers
93 views

Reporting - easy to build interface linked to a postgres database

I'm looking for a tool that can create reports but also interface that can manipulate data. These reports and interfaces will be deployed on Windows PCs. Access and Excel spreadsheets are excluded. ...
2
votes
2answers
181 views

PostgreSQL database explorer

I'm looking for a nice visual explorer for PostgreSQL. I found DataGrip by JetBrains. The issue is the price is high, at least for me. I would like to have another explorer, which is comfortable, ...
0
votes
1answer
60 views

Async Job Processing based on PostgreSQL

I search an async job processing system like celery or python-rq but based on PostgreSQL. Needed features: Async processing of jobs Uses PostgreSQL API for Python Store message in language ...
3
votes
0answers
1k views

Severalnines Clustercontrol Alternative software?

I have been dealing with ClusterControl software to provision MySQL cluster and monitor and scale from last few weeks. But they are not really responsive I tried to reach them to get a quote but they ...
2
votes
0answers
37 views

Generic query and display system for JSON stored in a database

I search a system which provides generic query and display of any JSON data. Imagine I have stored this in a row of a database table: {"foo": "bar", "foo2": "x"} I want a text input field where I ...
3
votes
1answer
46 views

Web interface where I can draw objects and export PostGIS insert statements

I am looking for an application that will allow me to draw a box or polygon on a map and then export the definition in a PostGIS database so that I can insert it into my own database. Currently, my ...
20
votes
7answers
37k views

Generate database table diagrams from a PostgreSQL database

I am looking for a GUI program that can generate database table diagrams from a PostgreSQL database. I am aware of SchemaSpy, SchemaCrawler and PostgreSQL Autodoc but they are CLI. Any OS, price and ...
1
vote
0answers
44 views

Best ERP solution for ecommerce site

my company is currently looking for an ERP solution that fits the following needs: Is able to connect with PostgreSQL. Is cheap (preferably open source) and accessible economically for a small sized ...
6
votes
4answers
2k views

PostgreSQL front end for adding, viewing and updating values

In the scope of a small community project we were compelled to create a database in order to manage our events, the participating members, their contact details and so on. I've created a PostgreSQL DB ...
3
votes
3answers
138 views

Simple business intelligence tool for scheduled reports

I'm looking for business intelligence tool which: is free can be deployed on premise (not in a cloud) can work with PostgresDB allows to create reports simply from SQL query (as spreadsheet or csv), ...
0
votes
1answer
374 views

Sort pg_dump output

I have a dump of pg_dump before and after an update. Unfortunately the COPY statements are not sorted. I want to get the dump into a format for easy diffing with the tool "meld". I could do this ...
0
votes
0answers
16 views

Editing the content of a PostgreSQL table through the data output of a query

I am looking for a Windows 7 or OS X program that can query a PostgreSQL table, and let me edit the table by editing the data output of a query. I know how to code it, but I am wondering whether there ...
0
votes
0answers
17 views

Converting create table statements from Oracle SQL to PostgreSQL

I am looking for a program that can converting create table statements from Oracle SQL to PostgreSQL (e.g., choose the closest type for each column). Any OS, any license, any price is fine. CLI or ...
0
votes
0answers
22 views

Database *data* version migration tool

I have two db servers: local and remote (dev). Remote dev version is being constantly changed including the app static data. While working on my copy I need to modify not only schema but also static ...
1
vote
0answers
57 views

Which ORM do you recommend to use with Node.js and PostgreSQL?

I'm doing a project where I will need to access PostgreSQL from Node. As I want it to be a more professional thing I want to use an ORM. What ORM would you recommend ? I expect that it: supports ...
5
votes
3answers
176 views

Postgres/PostGIS GUI aplication development tools

I am planning to use Postgres/postgis RDBMS on Windows platform 64bit for creating some user-friendly desktop or web application for populating a database, and I need a form designer tool like ...
3
votes
0answers
51 views

Database schema and data management tools

I've been using Visual Paradigm on both mac and linux to simutaneously manage my database's schema and example/test data during development. I have found their interface to only get buggier over time ...
2
votes
0answers
21 views

Looking for low footprint library for retrieving config values (typically key-value pairs) from PostgreSQL in Python 3.4 code

I am reviewing ways to configure a suit of Python scripts on a server side system. I am currently using JSON to configure the Python scripts. The configuration files say things like how many threads ...
1
vote
0answers
76 views

Is there a database wrapper that can share and roll back changes between multiple threads for integration tests?

I'm looking for a tool which can connect to a PostgreSQL database, run a series of queries potentially in multiple threads, then roll all those changes back. I've done some searching for methods and ...
1
vote
1answer
313 views

Which open-source monitoring product uses a PostgreSQL backend, can be automated, run on CentOS7 and use Nagios plugins?

Aim The aim is to replace Opsview that is used to monitor all systems and related processes in the company as it does not meet now-a-days requirements: PostgreSQL backend Open-source Automated ...
2
votes
1answer
122 views

Store GPS information in database

I need to continuously collect the location details of our users (say around 100K, at a frequency of 10 sec). What I am interested in is list of users near a particular location (i.e., I don't usually ...
2
votes
1answer
139 views

PostgreSQL UI that does not require PHP nor GTK

pgadmin requires GTK which I'm not going to install on a server. Is there PostgreSQL UI that does not require PHP nor GTK? Free, cross-platform. (Split from Is there a MySQL interface that doesn&#...
2
votes
3answers
128 views

RDBMS for newbies in IT

I need to teach my two interns how to use RDBMSes in general and "standard" SQL during their free time, using the outdated windows notebooks we have laying around. They come from math courses and have ...
10
votes
5answers
906 views

OS X PostgreSQL client with a GUI?

I've recently found a need to work with a PostgreSQL database. As I'm completely new to PostreSQL, I'd like to have a nice GUI for it, much like one for MySQL. It must: Support tunneling over SSH ...
3
votes
0answers
244 views

PostgreSQL-based shopping cart with easy database-level integration

I am looking for a shopping cart which is easy to integrate using triggers and other database-level procedures into other applications. The other applications are PostgreSQL-only. Absolutely ...

1
2