Questions tagged [postgresql]
If your question is explicitly for the PostgreSQL database (server or client). Targeting "any" database, rather use the 'database' tag.
0
votes
1answer
16 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/...
0
votes
0answers
19 views
How to abstract multiple DB tables?
I need to build a website which is served by live data in RDS (constantly updating data).
For every website request we join multiple tables and aggregate data - ex. SUM, AVG.
Since we join multiple ...
1
vote
0answers
5 views
Recommendation for structured data of peta bytes with lot of dynamic queries [closed]
Working on a application with PostgreSQL as back-end. I have several tables of which very few tables are very large. Lot of stream data goes in to these few tables. I have used stream feature of ...
0
votes
0answers
3 views
Postgres failure recovery automatic backup
I am developing an application using Postgresql, where database availability is critical. Can someone suggest some open source/paid solution which can handle below
Automatic backups, such that I can ...
0
votes
0answers
22 views
PostgreSQL free or open source profiler for Windows
What are the current best PostgreSQL free or open source profilers for Windows?
A profiler should be able to log traces of queries run on the server based on specific filters and also timings, CPU ...
3
votes
0answers
9 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 ...
0
votes
0answers
18 views
Recommended software for syncing PostgreSQL data and ReactNative mobile app data?
I am working on a web application written in Django and using PostgreSQL as the database backend. I'd like to spin up a ReactNative mobile app so that users can operate the app offline. I am concerned ...
0
votes
0answers
10 views
PostgreSQL query formatter which removes unnecessary parenthesis
When I ask postgres/navicat to give me the definition (DDL) of an existing view it gives a version which has way too many bells and whistles compared to what was used to create the view in the first ...
0
votes
0answers
10 views
GUI client for postgres json friendly
I am looking for a GUI client for postgres database that will allow me to edit my JSONs stored as JSONB datatype in a user friendly fashion.
So far, I edit JSONs in my DB writing SQL queries which ...
3
votes
2answers
68 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 ...
1
vote
1answer
40 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 ...
0
votes
0answers
14 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 ...
1
vote
1answer
30 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
31 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, ...
-2
votes
2answers
30 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 ...
2
votes
1answer
110 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 ...
1
vote
0answers
28 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
28 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 ...
0
votes
0answers
21 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 ...
1
vote
1answer
95 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
0answers
36 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
2answers
166 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 ...
0
votes
0answers
734 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 ...
5
votes
3answers
245 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
69 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
147 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
0answers
20 views
DB replication from 5000 sites to head office
I need to replicate certain sets of data from a master database site (head office) to multiple sites geographically distributed.
There is no specific software chosen yet for head office or the remote ...
0
votes
1answer
50 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
808 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
34 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
40 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 ...
10
votes
5answers
14k 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
34 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 ...
4
votes
4answers
304 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
114 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
265 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
15 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
16 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
21 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
53 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
118 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 ...
2
votes
0answers
43 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
310 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
114 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
128 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
125 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
779 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
208 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 ...
