Skip to main content

Questions tagged [postgresql]

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

48 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
0 answers
38 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 ...
guettli's user avatar
  • 207
3 votes
0 answers
2k 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 ...
Yousaf's user avatar
  • 141
3 votes
0 answers
62 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 ...
sam's user avatar
  • 131
2 votes
0 answers
30 views

Reverse-engineer PostgreSQL query into diagram

Is there a tool that can show a diagram of tables involved for a PostgreSQL query? Must support: WITH syntax Subqueries Joins Lateral joins Nice to have: Columns involved Recursive expand ...
pkExec's user avatar
  • 131
2 votes
0 answers
9 views

Easy to implement solution to build a geoportal on an intranet?

My Goal I am working for a small government agency and I would like to create a geoportal. What I mean is providing my colleagues with a browser-based interface from which they can access different ...
Damien's user avatar
  • 121
2 votes
0 answers
15 views

Postgres IDE for iPhone

What would be a good Postgres IDE for the iPhone? I am looking to be able to quick look up stuff or modify a function in one of my many schemas on the go.
Daniel L. VanDenBosch's user avatar
2 votes
0 answers
158 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 ...
ThoPa's user avatar
  • 21
2 votes
0 answers
324 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 ...
Jaxidian's user avatar
  • 121
2 votes
0 answers
36 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 ...
P.Brian.Mackey's user avatar
2 votes
0 answers
50 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 ...
guettli's user avatar
  • 207
2 votes
0 answers
25 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 ...
André Christoffer Andersen's user avatar
2 votes
0 answers
294 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 ...
Chris Travers's user avatar
1 vote
0 answers
12 views

PostgreSQL - explore data via table references/foreign keys

Using PGAdmin (or other free tools), is there a way to explore PostgreSQL table data via Foreign Keys? Let's say I have already selected a single record of a table via primary key (a surrogate key). ...
Eddified's user avatar
  • 111
1 vote
0 answers
10 views

Recommendations for tooling to extract scripts using table hierarchy

I am looking for a tool or open-source library which can use table dependencies to create insert scripts for PostgreSQL database. I am working on specific requirements to clone data related to a ...
prashant's user avatar
  • 111
1 vote
0 answers
12 views

Matching Excel inventory sheet with scanned UPCs and then feeding that into frontend of a Web App

I have an interesting use-case and I was wondering if my approach seems viable. I am in the liquidation business and I purchase merchandise by the truckload from an array of national retailers. I ...
user78474's user avatar
1 vote
0 answers
18 views

Overview of using Grafana for automated sql reports?

I have a couple types of databases (postgres, mysql) that I regularly run queries on and email the reports. I want a reporting dashboard to automate these tasks. I've heard Grafana is a good way to go,...
trouble_bucket's user avatar
1 vote
0 answers
24 views

What stack to use if I want to develop

Let's say I want to develop a Real Estate fullstack web application. With a Reactive map component Authentication Social Network authentication Image storage Data storage GIS querying capabilities ...
pokatore's user avatar
1 vote
0 answers
26 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 ...
EmirZ's user avatar
  • 111
1 vote
0 answers
16 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 ...
Mansel Cayler's user avatar
1 vote
0 answers
23 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 ...
Marion's user avatar
  • 21
1 vote
0 answers
138 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 ...
thesunnyscientist's user avatar
1 vote
0 answers
28 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 ...
Jvardas's user avatar
  • 11
1 vote
0 answers
12 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.
lucazpinheiro's user avatar
1 vote
1 answer
40 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/...
Alex's user avatar
  • 11
1 vote
1 answer
60 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 ...
Vinicius Morais's user avatar
1 vote
0 answers
49 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, ...
antew's user avatar
  • 111
1 vote
0 answers
47 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....
Fabian Lurz's user avatar
1 vote
0 answers
68 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 ...
Nelson Teixeira's user avatar
1 vote
0 answers
79 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 ...
Marsh's user avatar
  • 131
0 votes
0 answers
13 views

free web application to deploy on kubernetes with postgres backend

I am evaluating some of currently available kubernetes postgres-operators (cloudnativepg, zalando, crunchy etc.) For this evaluation, I also need a web application with postgres database on backend - ...
sqluser's user avatar
  • 111
0 votes
0 answers
17 views

Looking for a free macOS PostgreSQL client with AWS IAM authentication, OR can script the password field

pgAdmin4 can do this with the advanced "Password exec cmd" field, it basically automates the process described here. I just don't like pgAdmin4 so far. I understand DBeaver has native AWS ...
Rich's user avatar
  • 121
0 votes
1 answer
24 views

Is there a low-code tool for an SQL analyst to share interactive views and graphical CRUD interfaces?

I'm looking for a graphical interface around which to have live conversations about live data; something I can leave with a client for them to browse and perhaps update as they need, in their own time,...
Travis Well's user avatar
0 votes
0 answers
41 views

What database should I use for a location tracking android application?

So I want to develop an online mobile application using android studio and java. A client mobile application that will send its location to the admin mobile application, so it will be using GPS. what ...
Timow's user avatar
  • 1
0 votes
0 answers
201 views

What is a good database tool for offline access?

I'm trying to find the right database service to use. I need multiple computers (1-5) to be able to access/write/read to the database simultaneously, locally (without internet access, via connecting ...
user16369266's user avatar
0 votes
0 answers
49 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, ...
Kwsswart's user avatar
  • 101
0 votes
0 answers
182 views

Generate database schema diagram from PostgreSQL DDL files

I'm looking for online/offline software that accepts a SQL file with a CREATE TABLE statement as input and generates a database schema diagram like one below: I did some research and I know there's ...
balkon16's user avatar
  • 101
0 votes
0 answers
24 views

Fastest framework / method to perform multiple calculations on 11m rows x 12 columns of data from a csv

I have a CSV that is supplied from a 3rd party every morning. That csv requires processing, and I'm looking for recommendations as to how those familiar with data science / big data management would ...
anakaine's user avatar
  • 101
0 votes
1 answer
28 views

Visual Studio 2017 Enterprise C++ Connect to to Postgressql Server

What is the best way to connect from C++ to a postgressql server? An important limitation is that there can't be any additional software installations (some .exe or .misi files that install the driver)...
Willi's user avatar
  • 101
0 votes
0 answers
60 views

What database to use for CRM web app?

I want to develop Java based CRM starting from scratch. I have noticed many notable open source CRM use Postgres. I need to choose between MongoDb and Postgres. I prefer MongoDb because there will be ...
user61766's user avatar
  • 131
0 votes
0 answers
23 views

Which front end SQL client should I use with a Windows front end configured to a Postgresql back end?

I want it to be open source and runs on Windows. I have a Linux server running Postgres. Which free application is versatile, easy-to-use and secure? TOAD is not free. There are other open-source ...
user28720's user avatar
0 votes
0 answers
2k views

Development environment PHP + Nginx + PostgreSQL on Windows

How or which could be the best way to build a local development environment for a PHP + Nginx + PostgreSQL setup? I will start working on an app hosted on an AWS and am using Pycharm + Git for VCS ...
johan855's user avatar
  • 165
0 votes
1 answer
121 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 ...
guettli's user avatar
  • 207
0 votes
0 answers
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 ...
Franck Dernoncourt's user avatar
0 votes
0 answers
20 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 ...
Franck Dernoncourt's user avatar
0 votes
0 answers
24 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 ...
Vlad's user avatar
  • 210
-1 votes
2 answers
43 views

Tool to validate domains

Does anyone know a tool that can validate a list of domains(100+ domains) in one run? Below are the sample list of domains.
Michellin Yumul's user avatar
-1 votes
1 answer
21 views

Building a Data analytics website with PostgreSQL

I need help with someone giving me advice on how do I go about building a data analytics website with data from PostgreSQL. I research on Django framework to help build a data analytics website but ...
Nite's user avatar
  • 1
-2 votes
3 answers
56 views

Software to edit large raw datasets easily for PostgreSQL imports?

I have a few lists of 2 million rows or so consisting of: Name, Address, Phone Number but these have errors like multiple commas in a row. When I import these into postgres as .txt and comma ...
RayCrush's user avatar