Questions tagged [database]

A collection of data that is usually organized into tables for different data objects. Tables usually consists of records on instances of the data objects.

Filter by
Sorted by
Tagged with
0
votes
0answers
11 views

Handle info message for application user

I’m developing an administration software for a small family business using spring boot and angular. There are normal ‘users’ and one accountant / administrator using that application. It happens that ...
0
votes
0answers
20 views

MSSql Database randomly not answering

We have a 32 Bit production machine that has MS SQL 2014 installed. 32 Bit is forced by twincat 2 running on it, (not compatible with 64 bit), thus the available ram is limited. Randomly, about twice ...
0
votes
1answer
35 views

How to return first non-blank value with LOOKUP function

I have a table: table in which I reference data from a dataset using a LOOKUP function. I can reference columns(such as new_deaths) which have the latest(non-blank) data just fine. However, for some ...
0
votes
0answers
16 views

How do convert/parse/extract data from a PGN into a spreadsheet/google sheet/excel file? [duplicate]

So suppose I go to like https://api.chess.com/pub/player/gmwso/games/2020/12 or https://api.chess.com/pub/player/gmwso/games/2020/12/pgn there's gonna be a bunch of stuff like say [UTCDate "2018....
0
votes
1answer
50 views

Live statistics chess960 from chess.com?

Both lichess and chess.com have the feature to play the variant chess960 live. However, only lichess has a graph showing how your live chess960 rating has changed over time. Lichess also shows other ...
0
votes
0answers
14 views

Quickbooks Payroll Protection Program Reporting Problems

Many larger users of Quickbooks have found they cannot run the PPP reports needed to manage the COVID relief loans they received. Intuit has promised fixes to us for about a year but at this point, I ...
0
votes
0answers
15 views

How to recover a corrupt SQLite database which still contains valuable text, but no tables in DB browser?

I see that the sqlite database file contains text and some json syntax, but how can i extract all the text from sqlite database file in a more usable format? So I can edit it at least rescue the json ...
0
votes
0answers
22 views

How to open .bin SQL file

I'm stuck and not sure if somebody had similar issue. I have an old database stored as .bin files. It relates back to 2012. I can see an xml catalogue file which indicates to me that it is sql data ...
0
votes
0answers
9 views

Grafana can't get the data of iotdb time series database, Why?

guys! I recently encountered a problem. When I successfully used “iotdb-grafana” to establish a connection with the iotdb database.But I can’t get the image on the page where the chart is made. ...
0
votes
1answer
30 views

Almost everything disabled in MS Access

I received an Access database to work with today but it is locked somehow and I'm new to this so I don't know how to unlock and customize it according to my liking. There is no ribbon showing, only ...
0
votes
0answers
30 views

ODBC Data Source Administrator not working with Microsoft Access driver

I am trying to create a system DSN using the ODBC DS Admin (32-bit). I need to use the 32-bit version because I will be interacting with a program that is only compatible with DSN's created using the ...
1
vote
1answer
36 views

Cannot log in to the MySQL server _After data dir changed _cent os 7

I am having centos 7 and recently i changed my data directory of mysql from /var/lib/mysql to /test/sql after the migration i am able to login from mysql server through terminal but not able to login ...
0
votes
1answer
31 views

Excel Database for Questionnaire Results

I need to make an ongoing database for a questionnaire with 12 questions. The tick box options are Certainly True, Somewhat True, Not True and Dont Know.Each of these has a value. So if you select ...
1
vote
2answers
83 views

Auto Fill Forms For All Major Browsers

I am building a form hosted on my server. I want to save the user as many keystrokes as possible since this is form with many fields. Is there an autofill forms for other major browsers like Safari, ...
0
votes
0answers
34 views

Secure database connection from public IP

We have an Android App and a website that requires connection to local database. Working Scenario is Online Website (.net) is in one dedicated virtual server with public ip. Then we have another ...
0
votes
1answer
72 views

Solve Error without installing PostgreSQL on Mac? dyld: Library not loaded: libpq.5.dylib

I am using a Mac OS X software called TablePlus which throws an error when trying to perform a backup of a PostgreSQL 13 database that is running inside a Docker container. dyld: Library not loaded: ...
1
vote
1answer
52 views

disable (or trim) logging of bytea requests in postgres

Our application store some big blob (bytea) in a separate database every 30 minutes. It's fine and we want to keep it like, this, but it's causing crazy logging: 2021-01-25 11:11:00 UTC postgres109432 ...
0
votes
0answers
5 views

How to Docker Flask App Connection to My Local DB

Guys i have a project about flask and opencv like mix project and i'm trying to connect my-flask project in docker to my local database (not docker db) but i didn't how can i connect ?? I mean i have ...
2
votes
1answer
683 views

Turn .sql file into a table

I have an sql file (from the following link). I need to get the table which is supposedly encoded in that file. I have no SQL experience and tried several things that have been suggested elsewhere: I ...
1
vote
1answer
84 views

MS Excel - Combine tables with only some matching data

I have 2 sets of data that I want to combine into one table. I have tried to use Power Query but I don't think it can quite do what I am after and was wondering if there is another way. It might be ...
0
votes
0answers
24 views

Database error in browser

someone please tell me what this error is and how to get past it Error: The local database can't be opened. Your internet browser doesn't support local databases or saving to the local database has ...
1
vote
0answers
32 views

Oracle database on virtual box

Happy New Year to Everyone! My OS is linux mint. What I want to do: I want to install oracle database on virtual box and interact with it using the oracle sql developer installed on host os (mint). ...
1
vote
1answer
35 views

Location of Chrome autofill data?

I find how to view (browser) the Chrome autofill data. But i can't find the location of the database file. Anyone have the information for this?
0
votes
0answers
37 views

How do I add show Attribute Data Types on Visio 2016?

I've been trying to create a database schema using my Entity Relationship Diagram but no matter how many times I right click on an entity, show attribute types never pops up. Instead show stereotypes ...
0
votes
0answers
18 views

Mac, Installed a program that uses postgres, little snitch randomly notifies me, annoying, how can I stop this?

Anyone know how to acces/shut up postgres activity, shows as trustd, postgres, no option to set rule unlike other items, I rarely use the program, but I will later, I don't seem to be able to do it ...
0
votes
0answers
76 views

Can I merge two different (history.dp) files

Is there a way to combine "merge" two safari history.db files? or convert these files to plist? Thanks!
0
votes
0answers
18 views

Connecting to PostgreSQL through a SSH tunnel, I get data for a while and stops, but SSH connection is still alive

Im getting data from a PostgreSQL DB through an SSH tunnel: autossh -M 0 -o "ServerAliveInterval 30" -o "ServerAliveCountMax 3" -L 9999:localhost:5432 root@mypostgresip The data ...
0
votes
0answers
73 views

Can't connect to postgres database

Im trying to connect to a DB with Postgres JDBC, both machines are linux the firewall, selinux, iptables are down on both machines I can connect to the DB, (on my personal windows computer) with ...
0
votes
0answers
51 views

Libreoffice draw forms: how to auto populate combo boxes from linked database

I am currently working on a pdf form in libre office draw that I will use on a website. The form inputs amongst other things “department”, “address”, “phone number”, etc in combo boxes. For the about ...
0
votes
0answers
82 views

How to drop a table using mouse and context menu or main menu on DBeaver?

DBeaver is rather good with all the necessary features. However, something is missing. I'm using DBeaver to connect to PostgreSQL. The UI shows databases, table list, etc., right-clicking on a table ...
0
votes
1answer
203 views

How to create draw.io database diagram in Confluence from Excel?

I have a a list of fields in Excel which are the fields/columns of a table in my database. I want to convert this into a database diagram (ERD) in Confluence using draw.io. But I can't seem to be able ...
0
votes
1answer
33 views

CRA_Xcrms_ProcessRequest - what does it mean? or what process is this?

the Public Service Development Agency is going to give me access to database (Information about an individual in an electronic database). They contacted me and said that in the near future, they will ...
0
votes
0answers
134 views

moving multiple files to different directory on FTP webserver

So i have this webserver with a folder of approx. 7000+ files/images/documents. I want to move around 2000 specific images to a different folder. I think i can use SQL to get the image names from ...
0
votes
1answer
21 views

MS Access how to show records where in Field is “XYZ”

I Have a Query to show me records. I want it to show me all records when in a Field (lets name it Letters), is "XYZ". The thing is some entries start with XYZ, in some it's somewhere in the ...
0
votes
0answers
27 views

Sorting an excel column with numbers and keep track of cell indices

So, this is my problem, I have two excel columns like : 1 // 0.5 2 // 3.3 3 // 1.2 I would like to sort the second column in ascending(or descending) order, and also change the first column as ...
1
vote
1answer
39 views

A local key/value store for Windows

Is there any equivalent of sqlite as a key/value store that will run on Windows? I have a bunch of data in JSON files that I'd love to be able to view and query like I can with relational tabular data ...
0
votes
1answer
60 views

Including information from one database into another - MS Access

I have created a new table in MS Access which, for my purposes here, I'll call Table A. It contains a ton of information that staff need to enter for each company or individual. The forms are time ...
0
votes
0answers
32 views

Extract data from excel, based on one column condition SQL query should get the values and table name from excel sheet in python

Read the excel if column K9= pass through then read n,o,p and a,b,c /* TARGET */ 4.select count(*) from A9.B9 where column='C9'; /SOURCE/ select count(*) from N9.O9 where column='P9'; connect to ...
0
votes
0answers
17 views

Local database and GitHub — How do I check in?

I have a personal project I'm working on. I want to be able to go back and forth between my desktop and laptop via GitHub. The problem is, I can't figure out how to check in my "local" ...
0
votes
1answer
41 views

How to reduce multiple tables with different data into a master table (with at least one association)

Lets say that I have have 5 tables, all residing in different sheets. The tables all contain at least one dimension that can be associated with any other table. Some of the tables will share multiple, ...
0
votes
0answers
239 views

DBweaver cannot connect to postgres WSL2 ubuntu

Hello I am successfully using postgresql DB in my WSL2 ubuntu and its working fine, but i need to see data in DBWeaver but unfortunately I cannot connect as it shows no connection available, but if I ...
0
votes
1answer
521 views

Downloading wikipedia database for offline use

Here there are many ZIM files: https://dumps.wikimedia.org/other/kiwix/zim/wikipedia/ I want complete English Wikipedia with images... which one should I download? What is the difference for example ...
0
votes
0answers
18 views

Connect to Azure SQL Database

I have an Azure SQL Server that includes one custom database (let's call it my_db). Up to this point, I've been accessing this database using my server password. However, I want to make it more secure....
0
votes
0answers
79 views

How can I access a postgreSQL database from an android device?

I am designing a database in pgAdmin4 and postgreSQL. I am new in it, and I would like to know if there is a way to access and modify this same database from my mobile phone. I am trying with RemoDb ...
0
votes
2answers
756 views

How to view photos in “Photos Library.photoslibrary” created by Mac OS Catalina in Linux & Windows

I have a Mac. I also have a NAS. I sync files by using rsync(in the right way). After synchronization, I can see the "Photos Library.photoslibrary" is recognized by Linux as a folder. [i@one ...
0
votes
0answers
10 views

How to safe html-code in sqlite3 database?

I am currently working on a web-crawler written in Python. I am probably downloading 200 pages a day and want to store the html-code in a sqlite database. I have read that it would be good to create a ...
0
votes
1answer
19 views

Access deleted several records when data type changed. How to find which ones caused the errors?

I'm trying to work with an old Access database. It has a column formatted as Short Text that I need to change to numerical data. To attempt to change the data type, I opened the Design View and ...
0
votes
0answers
33 views

GNU locate (glocate) associated with gupdatedb to build database : is there a way to have the same behavior than on Linux for updates

I am working currently on MacOS Catalina but I post here since this is also about GNU/Linux. The version of default locate/updatedb on MacOS is not efficient since each time one launches an updatedb ...
1
vote
3answers
54 views

How to backup MySQL database on Linux server

Please I want to backup my database on a Linux server and I don't know how to go about it.
0
votes
0answers
13 views

Is there a newer alternative to DSNs?

I am not a DBA but my understanding is a DSN is a way to pre-define a database connection at system level. However it is also - and this is where I'm a bit fuzzy - limited to ODBC connections. Which ...

1
2 3 4 5
16