Questions tagged [database]
Software to create, manage, or interact with databases or software related to databases. For specific databases, please use the corresponding specific tag (see wiki).
612
questions
0
votes
0
answers
5
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 ...
1
vote
0
answers
23
views
Raw data spreadsheet
I use little tables that contain mainly text on a daily basis. I currently use LibreOffice Calc to view and edit them, with the Autofilter feature for sorting and filtering. However, spreadsheets are ...
- 11
1
vote
0
answers
14
views
Which free and opensource NoSQL database provides feature for creating groups/buckets of documents?
I am learning CouchDB. As I understand it, documents in the database cannot be grouped into categories, such as, for example, all receipt documents can be put into a receipt bucket, invoices can be ...
- 111
1
vote
1
answer
98
views
Linux CLI tool for auto-formatting (pretty printing) large SQL files
I've got a large (3 GB) SQL file that came from a SQL dump. Reading it is impossible because it's formatted poorly. For example each table has a giant INSERT statement that is indecipherable.
Is ...
- 111
1
vote
2
answers
29
views
Tool to manage and display n:m relations
I'm looking for something that can store, manage and display a fairly simple set of data and their relations. But since these are n:m relations, obvious solutions like Excel don't work well.
What I ...
- 411
1
vote
0
answers
15
views
Generate editable data grids for existing database (Lightswitch alternative)
We have an existing database that we need an editing UI for. For 70% of the tables we just need a simple editable data grid. The other 30% have one-to-many relationships that require a more ...
- 111
1
vote
0
answers
7
views
Need help on backend user account management and data persistence
So I'll keep it short. I have a website where my users can come and write and the strings of text are saved using their localstorage, meaning whatever text they write in that textarea stays saved on ...
- 11
1
vote
2
answers
59
views
Is there a database software that can accomplish this?
A professor at my workplace wants to setup a server for a database.
Users should be able to access the server with a GUI and create entries, add files to entries and edit metadata that is associated ...
- 11
1
vote
0
answers
40
views
Software for tracking how much time cows spend with each other, and who they interact with
I am looking for a software recognition camera software for mountain cows, that can see at night as well. This software would track each cow, looking at how much time each cow spends with another cow, ...
2
votes
1
answer
165
views
Searching in .csv files on Android smartphone
I am looking for an app that allows easy search within .csv files.
Minimal features
can somehow read .csv files
allows to search in them (searching for exact match of string in any column) is ...
- 1,062
0
votes
0
answers
11
views
What is the ideal database to use for an application that will hold unique user data of an expandable list of dictionaries?
I created a fitness tracker web app, currently I am using mongodb as the database. In my app each day will be a new dictionary of various keys that I will then push to a list in the User Schema. I ...
0
votes
2
answers
69
views
Open source SQL database scalable on commodity hardware?
Is there an open source SQL database specifically designed or optimized for scaling on clusters built from commodity hardware? In other words, something that does for data what Beowulf clusters did ...
- 101
1
vote
0
answers
19
views
Flat file document database with recursion
I am looking for a database similar to Sqlite in terms of usability, but that stores one single document instead. That is, basic data like integers, floats, bytes, and also lists and dictionaries(...
- 111
0
votes
0
answers
20
views
Simple Knowledge Base (database with web frontend) with API
Are there simple knowledge base (or just database with simple web-frontend) with HTTP API, especially API for searching items.
Idea is to
fill that base with some data with that simple interface (by ...
- 101
1
vote
1
answer
349
views
Which database is good for automotive GPS tracker?
we are developing a recording system for automotive gps trackers production of our company.
we log their data nearly 1 year and each gps node sends data to record each 5 seconds. each data contain ...
- 11
1
vote
0
answers
60
views
Python package that compares an SQLAlchemy ORM to a pre-existing database schema?
Is there a Python package that will compare a live database schema to one defined in an SQLAlchemy ORM?
I have a decent size MS SQL Server instance (6 databases, ~200 total tables) that I need to make ...
- 111
2
votes
2
answers
78
views
Customer data organisation tool
I'm looking for a tool, that stores our contact data from our customers/ clients.
Current situation:
Currently we store everything in an excel spreadsheet. With columns for: First Name, Last Name, ...
- 21
1
vote
0
answers
300
views
Recommendations for Stand-Alone NoSQL Database C++ Library
I am developing a Linux-only C++ open-source tool for (civilian) aircraft surveillance data inspection - think Radar data display and analysis (link).
Currently the app works with SQLite3, but I am ...
- 11
0
votes
0
answers
83
views
Amazon product advertising API alternative
Because my website is not online yet i could not use amazon products API in it, so I'm looking for an alternative that would let me do that.
so can you recommend any good free alternative to Amazon ...
- 101
0
votes
1
answer
29
views
Large (20m) data viewer with filter for int, float and date
I have 20m rows x 10 columns data looks like:
Col1 Col2 Col3 Col4 ... Col10
Row1 [str] [int] [float] ...
Row2 ...
...
Row20,000,000 ...
I am looking for a data viewer which supports:
...
- 198
0
votes
1
answer
218
views
Stand-alone Composer package for CRUD with PHP 8
For years, I've been making do with the outdated and ill-supported php-activerecord to do very simple insert and update operations for a tiny script that is for my own use and doesn't need to be a ...
- 113
1
vote
2
answers
30
views
How to use MySQL cloud services (gratis)?
I am new to web development. My team is planning to create a dynamic website as a project. I want to have a relational database (MySQL) but all tutorials seem to use MySQL and PHP locally. We want to ...
- 13
0
votes
2
answers
26
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
1
vote
0
answers
14
views
What database, cache or storage solution to use for large (~80GB) files?
Context
I have a bunch of image-like files that I need to store, and then retrieve and keep in memory as various calculations (only read operations) are performed on them. Imagine a library where you ...
- 111
0
votes
0
answers
26
views
which cloud db solution should I choose for fulltext search?
For my UWP and android apps, I started my project using firestore DB to store some user addresses and some business data, approximately 1M users data. Unfortunately, I missed to know in advance, that ...
- 103
2
votes
0
answers
14
views
Web application to manage data (podio alternative)
What I need is a recommendation, for an out of the box database with a UI on top.
Necessary features:
A database change log: every time an item changes, I need to be able to see what has changed.
A ...
- 121
1
vote
1
answer
42
views
ETL tool and database recommendation for Stock Analysis
I am planning to work on an project that does analysis on the Stock prices. The daily data gets fetched from an API end point. Before running the analytics and predictions, this data needs to be ...
1
vote
1
answer
83
views
Evernote with custom properties. Notion with full offline support
I need a desktop RDBMS to conveniently manage a bundle of rich text notes -- CRUD, adding tags, search inside notes, backups, etc. In a way, I need a light, abridged, desktop only version of Evernote ...
1
vote
0
answers
19
views
Software / Site for Comparison Lists
Wondering if anyone has a suggestion for either a website or a piece of software useful for recording information on things you're trying to compare?
Examples:
Looking for a house - would be nice to ...
- 11
0
votes
0
answers
12
views
What backed databases is best to use with a react native app?
For my final year project, I will be developing website and database for a property management company case study.I have chosen react native to develop the front-end. What back-end technologies will ...
2
votes
2
answers
70
views
Write a big comparison table
I want to write for myself a very big comparison table for myself. I want to write all the equivalent features (rows) for the programming languages I know (columns). For example, how to iterate over ...
- 21
1
vote
0
answers
11
views
What Python GUI software includes widgets that automate database transactions?
To give you an idea what I mean, decades ago, before I retired, I would have used Delphi for this type of desktop application. In that software you can connect a table display to a database table or a ...
- 280
0
votes
0
answers
26
views
CMS,front end,database and backend on one hosting
I'm trying to create a website for a client and the requirements are:
CMS to change data on the website
backend to integrate payments and authorization
front end
database to store info about payments ...
0
votes
2
answers
64
views
What database can I use to store data from sensors?
I'm working on a project where experimental data is collected from a bunch of sensors. There are several ways the data is gathered and used:
Some metrics are collected on regular basis. For instance, ...
- 273
1
vote
0
answers
19
views
Azure SQL Db to DB2 Sync
I need to automatically synchronize changes made in an Azure SQL database to our DB2 system. Whenever a change is made in Azure, DB2 should also be modified.
Azure DB creation is not started and table ...
- 11
1
vote
0
answers
8
views
Cloud service to send monthly email IoT sensor data
I am trying to develop a smart energy meter project in his the energy consumption and bill amount are calculated by Node mcu and sends data to cloud ,the cloud database should send this data to ...
- 11
3
votes
2
answers
79
views
Business Software Recommendations
We are currently using a MsOffice Access database for our company jobs lists and reporting for the last 15 years. We need to replace this system with something more stable for larger amounts of data, ...
- 31
0
votes
0
answers
28
views
Modern personal database solution for Windows
I currently use Simplenote to handle basic "databases" of a few hundred rows.
I'm looking to move away from Simplenote for these because:
This data is long-term and obstructs access to what ...
- 528
0
votes
1
answer
900
views
SQL to Pyspark Conversion
Suppose you are given a .sql file containing 10,000 lines of SQL commands and you were told to convert them to PySpark.
What software would you use?
...the task I want to accomplish:
Somehow automate ...
- 113
1
vote
1
answer
37
views
Choose database for multiple user desktop application
I am developing a Windows desktop application (.exe) for billing and inventory management using NetBeans. The application will run on multiple systems (10 - 12 on average), all connected in a wired or ...
- 11
1
vote
0
answers
17
views
Is there any way to make a small dynamic site using cloud services with a cost cap?
By cloud services I mean something that provides or makes it possible to set up:
A "database": almost anything that provides centralised persistent state, see below. By centralised, I mean ...
- 278
1
vote
0
answers
118
views
Tool for rapidly creating Web GUI for searching database on Intranet
I've a database with 20 million records in 5 tables and 150 fields. It grows by about 1%/day. We want to rapidly create an Intranet website where authenticated users can browse, filter, search and ...
- 111
1
vote
1
answer
34
views
NoSQL database for highly structured, many-index, mission-critical data with lots of relationships
I'm trying to find an alternative to SQL which is very horizontally scalable. However, many NoSQL databases have some features I need missing from SQL, or some other weird quirks.
I am developing an ...
- 111
1
vote
0
answers
11
views
What is a comprehensive integrated software stack for HR management, Learning Management, Financing and Procurement?
I'm looking for a comprehensive solution for Human Recourses integrated with a learning and courses provider management solution along with the finance management related to procurements, department ...
- 11
3
votes
2
answers
34
views
Item organizer with support for image copy/pasting, list reordering, and tags
I'm looking for a web app to organize generic "items", that have,
a link
one or more images
some free-form text note
Ideally the web app would also support structured fields that I could ...
- 954
2
votes
1
answer
91
views
Is there a lightweight SQL-capable database management software that doesn't try to be a server?
I'm looking for a program that's specifically not an SQL server. SQL servers seem to deal with permissions, connectivity, and all that jazz.
I just want a command line program that I can give an SQL ...
- 123
1
vote
0
answers
10
views
Create (and make accessible) DBs to be accessed through API [closed]
We produce regularly some data sets that might be interesting for the proper audience.
The DBs have some thousand enties and the entries have 15 fields in a tree form:
{
"item": {
...
- 11
0
votes
1
answer
65
views
Interactive PDF to management of reports
I am looking for some solution for management of reports. Is it possible to create interactive PDF with functions like:
add images
add attachments like images, emails, files etc.
sending information ...
- 1
1
vote
1
answer
9
views
Software for choosing the best output?
I am looking for a software which helps to choose between alternatives. The circumstances connected to social innovation, and the goal is to choose the best social innovation action based on several ...
- 11
1
vote
1
answer
105
views
Simple but performant databases?
I'm looking for simple but performant databases, e.g. PostgreSQL is performant but complex and full of feature, while lowdb is simple but not very performant.
So either a single list of DBs with good ...
- 113