Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

Database is an organized collection of data.

18
votes
11answers
25k views

Grep huge number of patterns from huge file

I have a file that's growing about 200,000 lines a day, and it is all formed with blocks of three lines as such: 1358726575123 # key Joseph Muller # name carpenter # job ...
25
votes
3answers
5k views

What kind of database do `updatedb` and `locate` use?

The locate program of findutils scans one or more databases of filenames and displays any matches. This can be used as a very fast find command if the file was present during the last file name ...
3
votes
1answer
5k views

How do I run a service with numactl

I need to do something like this to run MongoDB $numactl --interleave=all /usr/bin/mongod --config /etc/mongod.conf & What should I change to be able to run the mongo daemon with the options ...
0
votes
1answer
3k views

How to use grep and cut together?

Lets say I'm doing a database for fruits. Using a text file for it, inside contains, in this format, (Fruit:Quantity:Cost) Apple:10:1 Orange:20:2 Pears:10:3 Banana:20:4 10 Apples at $1 each. 20 ...
11
votes
2answers
963 views

Does anyone actually use and benefit from transparent huge pages?

I've been struggling with transparent huge pages performance issues of late, and noticed many database systems recommend turning it off. I am talking Oracle, Postgresql, MySQL, Cassandra, NuoDB, Redis,...
5
votes
5answers
12k views

Query Firefox password database

Braiam said that Firefox stores the password data for login websites in ~/.mozilla/firefox/key3.db and ~/.mozilla/firefox/signons.sqlite files. These files can be read with some sqlite editor. I ...
8
votes
1answer
4k views

Does quiesce exist for Linux?

Quiescing a file system allows you to make a backup of the database while it is still running and other programs and their data as well. The application generally needs to be notified of the quiesce ...
1
vote
1answer
155 views

PostgreSQL Accessible to Web Application

I have a server with PostgreSQL installed and there are scripts that are constantly modifying data in the database. PostgreSQL is running on it's default port 5432. I would like to be able to connect ...
-2
votes
2answers
173 views

cut an array column in csv [duplicate]

I want to cut an array column in a CSV file. For example if you see the below CSV file input.csv 1,2,"{1,2,3}",1 3,4,"{3,9,1}",2 8,9,"{10,12,30}",3 I want the output as output.csv 1,2,3 3,9,1 ...