Questions tagged [postgresql]
If your question is explicitly for the PostgreSQL database (server or client). Targeting "any" database, rather use the 'database' tag.
73
questions
27
votes
8answers
47k 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 ...
0
votes
0answers
11 views
Minimal and easy way to implement something like sharetxt.xyz?
I really like the service of sharetxt.xyz. I'd like to implement it, seems like the perfect "challange", but I feel I'm too noob to figure it out of my own. I hoped I could get some nice ...
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/...
0
votes
0answers
17 views
PostgreSQL front end for repetitive import of Excel data
I work in a laboratory where an instrument pushes data into a PostgreSQL database residing on a virtual machine running Windows Server 2019. Our chemists have an Excel template, which they fill out ...
2
votes
1answer
17 views
Stable PgAdmin alternative for querying Postgres SQL
I am using Postgres SQL with PgAdmin for quite a while now but it almost always crashes when our internal firewall kills idle TCP connections after a timeout. This bug seem to exist for years from ...
-1
votes
2answers
22 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.
0
votes
1answer
61 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 ...
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 ...
2
votes
0answers
5 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 ...
0
votes
1answer
19 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)...
3
votes
3answers
74 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 ...
0
votes
0answers
34 views
static analysis to validate sql queries
In IntelliJ IDEs, it is possible to statically analyze SQL queries of multiple dialects (PostgreSQL, MSSQL, SnowSQL). While this is useful during development, having these steps in the CI/CD pipeline ...
2
votes
0answers
10 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.
1
vote
0answers
15 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
...
2
votes
1answer
176 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
29 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 ...
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 ...
1
vote
0answers
13 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
14 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
25 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, ...
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 ...
2
votes
0answers
154 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 ...
0
votes
0answers
13 views
GraphQL Server: Apollo Engine vs express-graphql
Any advice appreciated!
Hello, I recently came up with a project, on implementing a booking/travel website. I will be using PostgreSQL for the database, and maybe MongoDB (NoSQL) in the future for ...
0
votes
0answers
23 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 ...
-2
votes
3answers
45 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 ...
1
vote
0answers
54 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 ...
3
votes
1answer
30 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 ...
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
0answers
19 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
votes
1answer
11 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 ...
0
votes
0answers
14 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 ...
2
votes
2answers
97 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. ...
0
votes
1answer
13 views
Looking for a SQL Client which will allow me to query data from two different database
I am currently using a SQL Client called Dbeaver to query data from Postgresql and MySQL database individually. But recently there is a use case, where there is a need to combine data from this two ...
3
votes
1answer
59 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
2answers
33 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 ...
1
vote
1answer
59 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
0answers
11 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.
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 ...
-1
votes
1answer
40 views
Connect from Postgres to sql server [closed]
I want to Connect from Postgres to sql server and fetch some data from a sql table to postgres.
I searched on internet and i found db_link but it is connecting only from postgres server to another ...
4
votes
2answers
105 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
46 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
29 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 ...
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
3answers
161 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), ...
2
votes
1answer
123 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 ...
1
vote
2answers
222 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 ...
5
votes
3answers
197 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
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 ...
1
vote
0answers
43 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:
...