Questions tagged [postgresql]
If your question is explicitly for the PostgreSQL database (server or client). Targeting "any" database, rather use the 'database' tag.
82
questions
0
votes
0answers
13 views
Relational Database and query interface with seeding and migration for Nodejs. Having 'n' no of DB's with dynamic db connection during every api calls
Statement :
Here i am working based on Multi-Tenant Architecture. so every client organisations need to have their own Databases and they are relational. so, in my case i need to work with " 'n' no ...
1
vote
0answers
13 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 ...
1
vote
0answers
116 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 ...
3
votes
1answer
28 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 ...
0
votes
0answers
3 views
PostgreSQL GUI client with Peer Authentication support
Does anybody know a GUI client for PostgreSQL, which supports "Peer Authentication" for password-less login into the database?
The CLI client psql does this.
0
votes
0answers
5 views
Ways to handle queries from xml files?
I'm working in a company which manages transport systems. Currently, we need to handle incoming information from XML files. Those are structured XMLs, basically they have a body which is called and ...
0
votes
0answers
5 views
Which is the best client for Mondrian?
Which is the best client for Mondrian supporting MDX queries? I read about Saiku but I am having problems to connect it to Postgres, in particular I have this kind of error: "Error while reading ACL ...
1
vote
0answers
14 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
10 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
6 views
Which is the good open source data visualisation tool
We have a Data ware house server running on PostgreSQL, We use Chartio as the data visualisation tool, but i has not many options for managing/creating complex reports.So i would like to get the ...
0
votes
0answers
12 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 ...
0
votes
1answer
7 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 ...
2
votes
1answer
34 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 ...
0
votes
0answers
13 views
Will a NestJS RESTful API (with PostgreSQL) work well with an Electron desktop application?
I am currently planning out a new project and would like some other opinions / recommendations for my project structure.
As the questions says, I am developing a desktop application using Electron, ...
0
votes
0answers
5 views
Oracle to PostgreSQL migration
To avoid licence cost we are analyzing the migration of hundreds of Oracle DB to PostreSQL. Currently Oracle DB uses all Oracle functions and in some cases RAC configuration.
Is it possible to ...
0
votes
0answers
8 views
Open source integration tool
Can anyone suggest an open-source application for integrating google sheets to Postgres? There are many available but most of them run for a trial period only.
0
votes
0answers
7 views
Performance Postgresql, it doesn't use all of resources
I have a dedicate server 32GB Ram, 12 Core CPU, 15000rpm HDD (raid 1)
i imported some data ( about 110 GB ) into the table to the postgres,
and i created partition Data on my table by date ( day by ...
0
votes
0answers
6 views
Software or tool to review pgsql code
I am looking for a code review tool which can check the stored procedure performance and suggest query optimization for the pgsql code.
Please suggest me .thank you.
0
votes
0answers
2 views
Optimal Postgresql, DynamoDB, Amazon Redshift integration for AI modeling?
Dear community experts
I was wondering if you will be as so kind to assist me with a quick question (will to be happy to explain more if you are willing to...).
I am researching and setting up a ...
0
votes
0answers
4 views
Optimal DB for bulk inserts with unique constraint on binary data field
I am trying to find the optimal DB for inserting binary data many times, when theres a unique constraint on it - there is a hash identifying each record, that can't be repeated. I'm interested only in ...
0
votes
0answers
6 views
Best Free SQL Program to Upload Excel CSV file
I am looking for a free program that works with Mac and is able to upload an Excel CSV file. The reason for this request is because I have an interview and the company gave me an assignment to write ...
0
votes
0answers
19 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
8 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 ...
2
votes
2answers
29 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
40 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 ...
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 ...
0
votes
0answers
89 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
55 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
13 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
14 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
35 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
12 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/...
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 ...
3
votes
2answers
84 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
43 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
19 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
36 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
37 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
38 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
133 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
30 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
33 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 ...
