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).

Filter by
Sorted by
Tagged with
2
votes
1answer
338 views

Hosted web platform for a small database application (back- and front-end)

I'm looking for a hosted database solution that allows you to define both the back-end (tables, views, relationships) as well as the front-end (forms, reports, ...). Both the number of tables as well ...
0
votes
1answer
32 views

Best database to store time-series data in memory on Linux? (Embedded application)

I currently working on a Linux embedded application where I do some logging every second for numeric data (I really just need to plot data on a graph for the last 24 hours of operations). Since SD ...
1
vote
1answer
37 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 ...
3
votes
1answer
40 views

Spatial search server, to quickly answer “What points near me?” requests

I have about a million points like this: Latitude Longitude Text (short text of less than 128 characters) I am writing an app that must quickly show what points are around the user. User: I am at ...
1
vote
3answers
4k views

Fast-to-set-up HSQLDB database management GUI

I am looking for a GUI to quickly check an HSQL (Hyper SQL) database. Requirements: Fast to set up Can be started from command line with filename as an argument See tables Run queries Open source
0
votes
1answer
37 views

What combination of toolsets is cost effective for hosting an intranet website?

Conditions: I need to be able to support a database that is small and multi-user access I need server-side and client-side programming/scripting I need it to be license free - or low cost, yet ...
1
vote
1answer
98 views

File-based database: Sqlite, MongoDb or else?

I am looking for a file-based database solution, where the original inputs are in csv format. Key info: One complete dataset is a static collection of files. However, I will need to have multiple ...
7
votes
1answer
178 views

A Database Management System that understands Relational Algebra Queries

I am a Computer Science student and we are currently learning Relational Algebra. I wish to be able to write Relational Algebra Queries and test to see what they return. Thus, I am looking for a ...
0
votes
1answer
55 views

Secure data transfer (for DB/ETL)

Does anyone know of any tool, ETL suite or BI suite that enables safe and secure data transfer from one location to another, over internet to an offsite database in the cloud? Or, what approaches ...
2
votes
0answers
10 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 ...
1
vote
3answers
399 views

Which tool to use for SQL Server Database migrations and why as of 2017?

I want to know a tool to use for SQL Server Database migrations and why as of 2017, since I worry about this topic, so I can automate this process as much as possible. What do you think about Entity ...
0
votes
0answers
14 views

What online/cloud databases can I use for Java desktop applications

I am trying to store customer repair request and complaints stored on a online database, so it can be shown on the sellers side. This will be done on my java desktop applications do you recommend any ...
0
votes
0answers
28 views

Offline REST DB

I am looking for an offline rest database so that I can provide server-side storage on my html pages without converting them to full stack server-side applications. It can be SQL or JSON based but ...
0
votes
0answers
12 views

Database with documents full text search anad tags searchs (java better)

Hi I am looking for a database or document base, with the feature to store documents (pdfs, words....) and do full text search in the content. Also search by tag and other columns that i will agree to ...
0
votes
0answers
20 views

Web CSM for database and search

I'm working with a small database built from spreadsheets, so I have several CSV files that may be related through column keys. I want to upload this work to a webpage and allow people to search ...
0
votes
0answers
24 views

Which OR mapper would you recommend for a new application (C# .net) with an existing database

We want to write a new application in C# that uses our existing database (SqlServer). There are many stored procedures and functions in the database. The database has several schemes. Which OR mapper ...
0
votes
0answers
30 views

Create survey questions from a database query

The following diagram (hopefully) displays what I would like. Say I have a database of pupil-teacher information from a school, two tables: one with pupil-class; the other class-teacher. The first ...
1
vote
0answers
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 ...
0
votes
0answers
11 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 ...
0
votes
0answers
12 views

Recommendations for website backend/frontend direction for SMB

I am looking for helpful suggestions for a website direction (or all-encompassing solution) for an online business that markets high value items on behalf of vendors, with medium-high monthly website ...
0
votes
0answers
11 views

Any software recommendation for data governance?

To ensure Data Governance is applied, any software recommendation for auditing 20 million rows of data in a database?
0
votes
0answers
9 views

Recomended database engine for write-intensive read-only use case

I a have a business case where i need to store a lot of messages for fixed amount of time. So let's assume 20 messages per second, each message is quite small and has at most 10-20 columns (about 100 ...
0
votes
0answers
38 views

Free embedded database with EF Core & async I/O support

I'm looking for a free embedded database that has async I/O support to be used in a desktop (C#/.NET, WPF) application. I'll be using the Entity Framework Core ORM so a suitable provider also is ...
0
votes
0answers
5 views

Edit database tables - Firebird

I would like to know a convenient way to edit tables in a Firebird database. (such as:what client, preferably free application would be suitable for windows 10/64 bit)
0
votes
0answers
6 views

Application to view extension (add-on) data stored in sqlite databases by Firefox

I have been searching for a Windows application to view data stored in sqlite databases created by Firefox extensions (aka add-ons/addons). So far, I have tried: Database Browser Portable DB Browser ...
0
votes
0answers
8 views

Java library to generate SQL INSERTS (DML) from JDBC ResultSet

Does anyone know a basic, no-nonsense Java library that will generate plain/standard SQL INSERT statements (as plain String) from a given JDBC ResultSet? Similar to what you can achieve when exporting ...
0
votes
2answers
44 views

Reverse Email Address Lookup and Email Validation

What is the best site or tool to do email address validation or a reverse lookup for the name attached to that email. I am working in a database for a company and they need to verify who their leads ...
1
vote
0answers
8 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 ...
0
votes
0answers
8 views

Recommendations for IoT project with Firebase

I need some recommendations for an IoT project. There is several remote ESP32 with many variables. We want to see them on a web dashboard with current status and logging previous variables. I have a ...
0
votes
0answers
8 views

Java library or tool for simple loading from a database

I work on a simulation program that reads data from a number of tables in a MySQL database. The database is read-only, and usually the queries are just SELECT * FROM .... Up to this point, the program ...
0
votes
0answers
12 views

Database for trading data in real time

I looking for recommendations to store and process (a little bit) tick market data from MT4 using ZMQ. I'm willing to store around 28 different instruments, but I have some questions regarding the ...
3
votes
2answers
53 views

What would be a suitable tool to do time series data comparison?

The running of an industrial process I'm in charge of produces time series data (approximately several thousand parameters, each 1/8th of a second, during a month). My goal is to look at two month-...
0
votes
0answers
9 views

Data explorer for Elasticsearch or Mongo

I'm working with a large data set that includes demographics information about people (voluntary survey participants). I'd like to be able to search through this data easily, to find people that match ...
0
votes
1answer
59 views

Reliable software for organizing notes

I'm looking for software which can help me organize all my categorized notes or pages (private data, links, thoughts etc) in exportable database. Preferable freeware or crossplatform.
0
votes
0answers
11 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 ...
41
votes
8answers
27k views

Free software to reverse engineer existing complex database diagrams in SQL Server 2008+

Up until a few years ago I used Microsoft Visio to reverse engineer an existing database to a diagram. This feature has been deprecated for a while now, and I'm rather stuck in finding an alternative. ...
0
votes
0answers
6 views

Gui based database version control for Postgres

As the title implies, I'm looking for a piece of software that would allow my non-programmer collegues to apply database versioning in the same way that for example django or alembic does. The idea is ...
0
votes
2answers
26 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, ...
1
vote
0answers
10 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 ...
4
votes
1answer
109 views

Customer management database

I work in a small company that gets around 600 new contacts every year (via email or contact forms). Right now, we are keeping all contacts information in an Excel sheet that we share on Dropbox, ...
0
votes
0answers
29 views

Serializing gamestate to database JavaFX in Intellij IDEA

I'm in a programming competition where I need to create a virtual board game. One of the requirements is serializing the game state to a database to load when a user opens the application again. Are ...
0
votes
1answer
30 views

Open-source software with API to manage very dynamic data tables

I'd know if there's any open-source software with API aimed to handle a (virtually) infinite number of tables of semi-structured data. What I already know Relational databases We all know that the ...
0
votes
0answers
6 views

Demographic augmented or virtual reality app to overlay job information on map or household buildings

I am looking for an augmented reality or virtual reality application where you can get a feel for the distribution of jobs across households in any area of the world you like by walking around, really ...
1
vote
0answers
7 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 ...
3
votes
2answers
71 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, ...
0
votes
1answer
32 views

Nodejs ORM for MYSQL

The purpose to find recommendation for a node-js package to interact with mysql db which can achieve following objectives It should be highly documented Resolve maximum of MYSQL query handling in ...
0
votes
0answers
19 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 ...
0
votes
1answer
42 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 ...
1
vote
0answers
156 views

Open-Source Web application for creating forms to query a database

What I imagine is a tool on which you can select your SQL database (ideally any of the RDBMS but if it is limited preferably PostgreSQL). In said tool administrator can create query and result forms ...
3
votes
5answers
209 views

DB and offline sync which works in browser

I want to build a web app which should work offline. +----------------+ +---------------+ | Browser | | Server | | | | ...

1
2
3 4 5
12