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
21
votes
7answers
38k 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 ...
10
votes
5answers
907 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 ...
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 ...
5
votes
3answers
411 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 ...
5
votes
3answers
179 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 ...
4
votes
0answers
20 views

Tool which stores the journal of systemd in a PostgreSQL table

I search a tool which stores the journal (logs) of systemd in a PostgreSQL table. Required features: open source No single log entry should get lost No duplicates should get created. efficient: N ...
3
votes
3answers
140 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), ...
3
votes
1answer
29 views

One do-it-all relational database or multiple stores for different purposes?

(Apologies if this question is better suited to Software Development or DBA!) I'm planning a system to store and view a library of 10-50k documents and am trying to work out the best option for ...
3
votes
2answers
93 views

Choosing the framework to an IDE type of web gui

I'm pretty newbie (or maybe oldie) with GUI development. Now when digging in, there seems to be massive amount of different frameworks to use. Currently I have built a java application which scrapes ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
2answers
184 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, ...
2
votes
2answers
31 views

Data visualization for webapps?

I have a Postgres database that feeds into a webapp. I would like my users to be able to run set inquiries on the database to get real-time reports and export data as .csv files. They would not be ...
2
votes
2answers
49 views

Alternate SQL language to PostgreSQL

I am going through a course in Udemy that teaches SQL using PostgreSQL. Yesterday I wanted to solve some SQL questions on Hackerrank. But it does not have the option to write in PostgreSQL. It has ...
2
votes
2answers
94 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
1answer
47 views

MS Access or alternatives for database front-end?

I am currently in the process of converting our company's database from a proprietary software to PostgreSQL, and would like a form-based front-end that is simple for computer laymen to use. Most ...
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
0answers
18 views

Frontend for CRUD operations Postgres

I need a frontend for CRUD Operations on a Postgres database. It has to be understandable also for persons without database background. Also it would be nice if it is open source and free (and maybe ...
2
votes
0answers
140 views

Index Analysis and Tuning tool for PostgreSQL, MySQL, and Oracle?

I have used SentryOne Plan Explorer to perform index tuning and index analysis with great success on SQL Server and Azure SQL Database. What are some of the better equivalent tools to consider for ...
2
votes
1answer
161 views

Sync local postgres db to a cloud postgres db, as a Windows Service

I'm looking for a software that will sync a local postgres db to a db in the cloud, like what Tableau can do with this service. This software has to be installed like a Windows service. It can be ...
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 ...
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
2answers
215 views

Open source or free online dashboard

I am planning a small project which involves the use of online dashboards but I'm having trouble finding nice free ones. By nice I mean, performant, appealing to the eye and flexible (I know I ask for ...
1
vote
2answers
14 views

Open Source Web Mapping with OpenLayers & PostGress SQL

I am planning to develop a web map application software which will run via a browser and for that I want to use open source. I already have some knowledge of OpenLayers & PostGress SQL. I want to ...
1
vote
1answer
57 views

Choosing the right database management system?

I am writing a Telegram bot script which needs to store inputted user data. I have no real experience using database management systems such as SQLite, MySQl and Postgres. I don't need my application ...
1
vote
1answer
44 views

Solution for a Data warehouse of about 7 GB

We recently deployed a new 'data lake' on the Azure platform. The decision-making process had been messy and I cannot shake the feeling that we have bought an expensive, unwieldy database while we had ...
1
vote
1answer
123 views

tools to create SQL queries through a graphical interface

I'm looking for a tool other than Access that can create SQL queries, through a graphical interface. This is what I'm trying to do Adding some details, my database is on Postgres and I'm using the ...
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 ...
1
vote
0answers
11 views

Firebird or PostgreSQL for POS application - What do you recommend (any advice, experience)?

I am about to start POS application development and I can not decide between Firebird and PostgreSQL. (Firebird 3 or PostgreSQL 12) As for functionality both DBMS have everything I need. When it ...
1
vote
0answers
10 views

Is there such a thing as a “PostgreSQL-SQL-to-OtherDB-SQL” converter in PHP or at all?

I use PostgreSQL exclusively. I have no plans to ever change this. However, I recognize that other people are not me, and they instead use MySQL, MS SQL, IBM SQL, SQLite SQL, Oracle SQL and ManyOthers ...
1
vote
0answers
6 views

Web-based GUI to query postgres db including JOIN ability?

I'm aware of the jQuery builder, but if I understand correctly this doesn't allow the user to join tables. Is there an alternative that allows for join? I'm looking for something for users who don't ...
1
vote
0answers
28 views

Web frontend for Postgres database

I have a Postgres database which I need to serve to colleagues via a web-based front end. Criteria: search and filter through relevant tables in the database and return records be able to draw onto ...
1
vote
0answers
17 views

Right tools to implement logging and monitoring

My team and I recently started working on a new project. Our project is layered in 3 tiers - client (Winforms Application), middle ware (.NET Core 3.0 Web API), Database (PostgreSQL). I was assigned ...
1
vote
0answers
10 views

Is there a tool to modeling a db?

I'm looking for a tool that will generate a logical model of permissions for each user in my db. I've been using PgModeler, but i'm looking for alternatives that allows modeling role's permisions.
1
vote
1answer
26 views

Docker High Availability for Stateful Applications Between Geographically Distant Datacenters

What is the FOSS solution that provides High Availability to stateful docker apps between geographically dispersed data centers? OS: CentOS 7 FOSS: no support contract Specific requirements: HA/...
1
vote
1answer
40 views

Is there a way to separate the rows of table in multiples machines (PostgreSQL)?

I have a application (Postgres) where there are a lot of rows (over millions) and I have to make a lot of INSERTs and SELECTs at the same time. And I'm thinking to make a cluster of machines. I tried ...
1
vote
0answers
41 views

Installation package generator for Postgres, Tomcat, Java (jre) and a war file

My aim is to build a silent installer to install the following components on a user machine. Postgres including PgAdmin, Apache Tomcat 7 Java (JRE) 7.0 And a war file I am targeting Windows only, ...
1
vote
0answers
31 views

IDE for Creating PostgreSQL C extensions

Could someone recommend an IDE for Creating PostgreSQL C extensions on Linux platform ? I'm currently using ATOM to program in C. But the C extensions for PostgreSQL use macro, for exemple: ...
1
vote
0answers
34 views

Is there a schema search tool for postgresql?

Is there a schema search tool similar to Redgate SQL search available for postgres (preferably free or part of jetbrains suite)? I need the ability to do things such as scan a database(s) for the ...
1
vote
0answers
42 views

Database Diffing tool/library

I have a testing database and a production database. I want to update/insert the changes that i did in the testing database. I already read this post about database diffing: https://stackoverflow....
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 ...
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 ...
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 ...
0
votes
1answer
381 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
8 views

Tool to generate User Interface from PostgreSQL tables

I'm looking for a tool that would generate simple application/UI out of DB. Something like "PostgreSQL PHP Generator" -> https://www.youtube.com/watch?v=RpA-50gqQKs It reads and analyzes ...
0
votes
0answers
19 views

Database for student and progress attendance web application

In the project I want to do I will be requiring a database for the following: Store and access login details for Admin, Managers and Faculty. Store students and their information, i.e. Phone numbers, ...