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
0 votes
1 answer
12 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,...
0 votes
0 answers
22 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 ...
  • 1
0 votes
0 answers
18 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 ...
0 votes
0 answers
4 views

Enterprise data modeling tools for Postgres

Is there anyone who is using an Enterprise data modeling tool (i.e. ERWIN, ER Studio) with Postgres? We have used ER Studio for Oracle for over 15 years, our process is to use the tool to take a ...
0 votes
0 answers
26 views

PostgreSQL client with boost::asio integration

My team is in the process of rewriting a legacy application written in C/libevent to the modern tech stack (we decided to use C++20 and boost::asio). The old implementation suffers from poor ...
0 votes
1 answer
26 views

Is there an online SQL compiler with a multi-table database for practice?

I want to practice my SQL. My first instinct was to install a database management system (such as PostgreSQL), download a well-known database and practice on my local computer. However, I was ...
1 vote
0 answers
11 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 ...
0 votes
0 answers
10 views

Tool to migrate postgres database to changed tables

I have an express project that uses postgresql to store and retrieve data. The database can be initialized with a file named tables.sql. In those all the tables are defined and they are executed using ...
1 vote
0 answers
12 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,...
0 votes
2 answers
22 views

Do tools for generating documentation of PostgreSQL data warehouses/databases exist?

Something like Sphinx but for SQL, so we could document table structures and relationships in a series of web pages.
  • 121
0 votes
2 answers
77 views

open source tool for SQL Queries

I program in SQL, however I am not someone who comes from IT. In my new job, we have to choose an open source tool for doing only queries (using SQL language), it means we are going to connect to some ...
  • 1
2 votes
1 answer
19 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 ...
  • 121
-1 votes
2 answers
27 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.
2 votes
0 answers
7 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 ...
  • 121
2 votes
0 answers
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
0 answers
22 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
0 answers
75 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 ...
  • 21
1 vote
0 answers
17 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 ...
  • 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 ...
0 votes
0 answers
37 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, ...
  • 101
1 vote
0 answers
9 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 ...
  • 21
0 votes
0 answers
70 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 ...
  • 101
1 vote
0 answers
117 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 ...
2 votes
0 answers
257 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 ...
  • 121
3 votes
1 answer
32 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 ...
  • 133
1 vote
0 answers
20 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 ...
  • 11
-1 votes
1 answer
18 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 ...
  • 1
0 votes
0 answers
22 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 ...
  • 101
0 votes
1 answer
23 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
1 answer
104 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 ...
  • 133
2 votes
2 answers
42 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 ...
  • 21
3 votes
3 answers
291 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 ...
  • 131
1 vote
2 answers
24 views

Open Source Web Mapping with OpenLayers & PostgreSQL

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 & PostgreSQL. I want to use ...
  • 11
1 vote
1 answer
76 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 ...
  • 19
0 votes
1 answer
23 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)...
  • 101
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.
-1 votes
1 answer
41 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 ...
1 vote
1 answer
28 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/...
  • 11
4 votes
0 answers
27 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 ...
  • 109
3 votes
2 answers
138 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
1 answer
49 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 ...
  • 131
0 votes
0 answers
39 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 ...
  • 131
1 vote
1 answer
49 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
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, ...
  • 111
-2 votes
3 answers
50 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
1 answer
227 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 ...
  • 137
1 vote
0 answers
32 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: ...
  • 11
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 ...
0 votes
0 answers
22 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 ...
  • 31
1 vote
1 answer
137 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 ...
  • 137