Skip to main content
26 votes

Setup a Docker container to work with a local database

There are three ways: Use the --net=host option. This network mode essentially means that the container has direct access to localhost and you can now access localhost:3306. Here's the command ...
Clive Makamara's user avatar
10 votes
Accepted

What embedded database format is used by this Chrome extension?

It’s LevelDB, a key-value store. You can use NodeJS and levelup to access the data: var levelup = require("levelup"); var db = levelup("path/to/directory"); db.createReadStream().on("data", data =&...
Daniel B's user avatar
  • 63.9k
8 votes

How do I repair a corrupted Firefox places.sqlite database?

This process described on MDN helped me resolve an issue where new pages I visited were not recorded in browser history. I did not have a places.sqlite.corrupt (or places.sqlite-corrupt) file, but ...
Daniel's user avatar
  • 278
8 votes
Accepted

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

The delete functionality is hidden by default, but it is there when using the Advanced connection view. You can enter the view by right clicking on the connection you're using and changing Connection ...
Bram van Dalen's user avatar
8 votes
Accepted

locate command does not work on mac terminal

You can try to delete (or move) the locatedb file, e.g. mv /var/db/locate.database /var/db/locate.database.backup and then regenerate the database from scratch using /usr/libexec/locate.updatedb. You ...
skowalak's user avatar
  • 290
7 votes
Accepted

Creating a SQL Server Compact Edition database file in Microsoft Visual Studio 2017

Creating a SQL Server Compact Edition database file in Microsoft Visual Studio 2017 Microsoft is dropping support for SDF files with Visual Studio It appears Microsoft deprecated SQL Server Compact ...
Vomit IT - Chunky Mess Style's user avatar
6 votes

mysql: ERROR 1524 (HY000): Plugin 'mysql-native-password' is not loaded

I recently encountered the same problem but with mysql 8.4. So the solution as per mysql documentation is start the server with --mysql-native-password=ON (added in MySQL 8.4.0), or by including ...
shahonseven's user avatar
5 votes

#126 - Incorrect key file for table '.\mysql\db.MYI'; try to repair it

Exactly the same happened to me, I tried the following query and it worked: USE mysql; CHECK TABLE db; If it returns db is corrupt, then repair it using REPAIR TABLE db; CHECK TABLE db; You should ...
Pratik's user avatar
  • 51
5 votes

InfluxDB failed to start as a service

I found the problem: [dadmin@localhost dashboard]$ sudo tail /var/log/messages May 11 16:21:41 localhost influxd: [I] 2017-05-11T14:21:41Z Using data dir: /dashboard/influxdb/data service=store May ...
Davide's user avatar
  • 131
5 votes

How to read key3.db and logins.json in plain-text?

What I did on Linux: Grab nss source package for your distro. Unpack, patch and configure. Go to nss/cmd/pwdecrypt subdirectory Build pwdecrypt tool. I used the following command line to build the ...
Tomek's user avatar
  • 1,228
5 votes
Accepted

Database server for web browser

I am assuming they must have a database server the same way a web application has a database server. What is the basis for that assumption? Web browsers and web applications are different things and ...
grawity_u1686's user avatar
5 votes
Accepted

Is the format/schema of the Apple Music “Library.musicdb” used in macOS Catalina documented anywhere?

There's a framework called iTunesLibrary that can read Music.app's database - just tested this on macOS Catalina - but it's an Objective-C one. You may be able to use it via PyObjC, but it will only ...
Matteo Pacini's user avatar
4 votes

Is the format/schema of the Apple Music “Library.musicdb” used in macOS Catalina documented anywhere?

While Apple Music does not automatically generate an library XML file, this can be done manually in the app itself. I realize this question is about the format of the actual Music Library.musiclibrary ...
Giacomo1968's user avatar
  • 56.1k
4 votes

Turn .sql file into a table

This is a MySQL dump file. You can run it against a MySQL or MariaDB database. Both applications are available for the Mac. Install either MySQL or MariaDB. If you are familiar with the terminal, you ...
jamieburchell's user avatar
4 votes
Accepted

Power Query Editor: Why are null Values Matching on an Inner Join?

According to the Power Query language specification, the equality operator is defined on null values. Please also see the discussion: https://stackoverflow.com/questions/53119042/power-query-merging-...
FlexYourData's user avatar
  • 6,933
3 votes

SQL : Restrict view of tables in database

Yes you can, like this: GRANT [Permission] ON [SchemaName].[TableName] to [UserName] Where [Permission] is SELECT, UPDATE, DELETE, or INSERT. You can also use DENY instead of GRANT to take ...
imtheman's user avatar
  • 4,663
3 votes

What embedded database format is used by this Chrome extension?

The files are in LevelDB format developed by Google and the code is hosted on GitHub. Potentially you can use leveldb-json utility to export the data by pointing to the .indexeddb.leveldb folder, ...
kenorb's user avatar
  • 25.8k
3 votes

What happened to WinFS?

Hal Berenson, the General Manager of what would become WinFS wrote an excellent four-part blog series after Bill Gates disclosed in 2013 that his biggest regret from his time at Microsoft was the ...
3 votes

Excel: How to create multiple records from a single record

This will suffice for your example. You will need to modify a bit to match the real database. Example Data Company | Address | City | State | ZIP | Phone | GM | EmailGM | PD | EmailPD | SM | ...
Vylix's user avatar
  • 1,754
3 votes

How to read key3.db and logins.json in plain-text?

To list the Firefox or Thunderbird logins with passwords, you can use this firepwd Python script. To install it on a Debian/Ubuntu system: wget https://github.com/lclevy/firepwd/archive/master.zip ...
mivk's user avatar
  • 3,776
3 votes

Setup a Docker container to work with a local database

As of Docker v18.03+ you can use the host.docker.internal hostname to connect to your Docker host. This is for development purpose and will not work in a production environment outside of Docker ...
Timofey Bychkov's user avatar
3 votes
Accepted

Link to Skyward Database to MS SQL Server

Confirm you have access to authenticate Based on your screen shot showing the use of Integrated Authentication and it failing, you will want to confirm the account which you are signed on as and ...
Vomit IT - Chunky Mess Style's user avatar
3 votes

Microsoft Access how to get a field name to only show with certain entries

What you're asking about is called database normalization. This is a design process database designers use to eliminate redundant or inconsistent data from a DB. In your case, having a Number of ...
I say Reinstate Monica's user avatar
3 votes
Accepted

Use Notepad++ to convert file content format

This will replace the second semicolon with a linebreak Ctrl+H Find what: ^[^;]+;[^;]+\K; Replace with: \n or \r\n depending on your needs check Wrap around check Regular expression Replace all ...
Toto's user avatar
  • 18.2k
3 votes

I am using DBeaver and go the error 'FATAL: database "postgres" does not exist'

In Database Navigator > Right click on PostgreSQL > Edit Connection In Connection settings > general tab, enter your host (e.g. localhost), database (e.g. postgres) and leave User blank. Check Show ...
Joseph K.'s user avatar
  • 131
3 votes
Accepted

Downloading wikipedia database for offline use

It seems en_100 refers to a category, or it could mean top 100. As for the sizing: Mini: only the introduction of each article, plus the infobox. Saves about 95% of space vs. the full version. nopic: ...
iskyfire's user avatar
  • 769
3 votes

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

Yes, this was asked and answered over on Stack Overflow: https://stackoverflow.com/questions/1244778/where-do-i-get-libpq-source You might need some familiarity with compiling open-source SW, but ...
jimtut's user avatar
  • 1,646
3 votes
Accepted

What is the difference between "client-server" and „file-server“ database?

The correct answer depends on who wrote the exam question (you should be asking your actual teacher for resources), but this is how I understand the terms: In "client-server" databases, the ...
grawity_u1686's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible