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
-1
votes
0answers
8 views

Recommendations for how to remotely host a mysql database

I am currently working on a university project which involves creating a simple java app to be run on other peoples computers as an executable jar file. As part of this, a database is required to hold ...
0
votes
0answers
18 views

Tool to create an entity and relationship model diagram inside PostgreSQL

here in my work we use PostgreSQL as a database, we are doing a restructuring in the database and we need to create the entity model and relationship between the tables. As it seems to me, PostgreSQL ...
0
votes
0answers
7 views

Best database for embedded application

I'm developing a nodejs api server for a single board computer with 2 GB ram and 16 GB SD card (ODROID-HC2). The OS is Ubuntu Linux. I need a database mainly for admin purposes. Data collected from ...
0
votes
0answers
4 views

What tools would you recommend to request PgSQL?

For my analyses, i'm doing a lot of specific requests to my PgSQL Database. Actually, i'm using PgAdmin 4 but i'm not satisfying because i can't make tab like we can do on a browser. Moreover, there ...
0
votes
0answers
10 views

postgresql database authentication with ssl cert

I am trying to use ssl auth for client and server(postgresql server) communication instead of plain password. I got it working by using self signed certs by creating cert with common name matching the ...
1
vote
2answers
18 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 ...
0
votes
0answers
3 views

how to sync database from MS SQL to PostgreSQL

I have to do database sync from MS SQL to PostgreSQL. Intially i thought to do transact replication but MS SQL is not supporting Postgresql while creating Non SQL subscriber in subcriptions. Any ...
0
votes
0answers
6 views

Compare an Oracle database with a Postgresql database

We are currently migrating an Oracle database to a Postgresql database. However, the Oracle database is huge and we want to check the quality of the migration. Do you know a tool that can compare an ...
2
votes
2answers
33 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
4 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 ...
0
votes
0answers
14 views

Is there any real project using Django with Orientdb?

I have searching about a few days, for recommendations about to use or not Orientdb with Django for a social network project, but I have found different opinions with many differences. I read some ...
1
vote
1answer
51 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 ...
0
votes
1answer
11 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)...
0
votes
0answers
8 views

Procedural Debuggers for Postgresql

I am curious about postgresql and would like to try it out. What other procedural debugger tools are out there? Which one do you like best and why? Here is one: https://www.pgadmin.org/docs/pgadmin4/...
0
votes
0answers
4 views

Program that monitors directory for incoming JSON data (like Filebeat) that inserts into Postgres database?

I have a Python script that appends data to a text file multiple times/second. The data is housed in JSON structure. Currently, I use a program called Filebeat to insert data into an ELK stack. I ...
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.
0
votes
0answers
11 views

Sync Postgres db from local to cloud

Here is my use case: Data source: I have several Postgres databases which are stored locally. Data destination: I would like to collect the data from all these sources and store them in a central ...
-1
votes
1answer
21 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 ...
0
votes
0answers
11 views

Transfering data from aurora to sql server

I am using auorora postgres database and sql server. Can you recommend a way how to transfer 100M rows table from aurora to ms server? I was trying to use spark for this issue and as I understood ...
0
votes
1answer
22 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
7 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
6 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
114 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 ...
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 ...
0
votes
0answers
34 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
15 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
17 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
77 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
42 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
17 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
34 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
34 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
35 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
126 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
29 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
32 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
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 ...
1
vote
1answer
110 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
39 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
182 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
836 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
280 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
80 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
151 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
22 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
54 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
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 ...
2
votes
0answers
36 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
45 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 ...