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.

learn more… | top users | synonyms (2)

4
votes
2answers
5k views

How can I create a database in PostgreSQL on Windows 7?

I use Windows 7 on my own home computer. I have installed PostgreSQL and now I would like to create an database. I tried with createdb mydatabase but I got this error message: createdb: could not ...
2
votes
0answers
127 views

What desktop computer hardware specifications are most important for database heavy applications?

I am purchasing a new personal desktop computer with the hope of improving performance for database-heavy applications (mostly data mining). I will want versatile hardware for all sorts of future ...
1
vote
1answer
28 views

Excel 2010 - Large Practitioner Database Consolidation

I have a database of 1800 employees (1 employee per row) and a binary confirmation of whether they have 1 or more of the 105 professional certifications we track (1 certification per column). I ...
0
votes
1answer
42 views

Mirror server and ignore already-processed files

Before I start writing my own app for this, maybe there is already a better solution for the problem: I need to check an HTTP Server every day for new files to download and process. Basically these ...
0
votes
1answer
16 views

Calculating non duplicates

I have below data in three columns A B C 07002 72J217.4 72J217 07002 72J229.5 72J129 07002 72J229.6 72J129 07002 72J229.7 72J129 07006 61E001.5 61E001 ...
0
votes
1answer
54 views

Split database index and table files with SSD?

I know in the good old days it was recommended that indexs and tables were placed on different drives to improve database performance. Is this still the case with SSDs when connected with SATA3? With ...
0
votes
1answer
286 views

delete a MySQL database with a strange name

I started to maintain a MySQL database and I have no idea who and why this database was created: "#mysql50#backup-2012-03-01". I want to get rid of this one, but the following commands did not work: ...
1
vote
1answer
48 views

Tool for converting tables into 2nd, 3rd and 4th normal forms? [closed]

I'm looking for a tool that will convert a table, in CSV format, into 2nd and 3rd normal forms. I've found many tutorials and examples on the process, but no tools. I'm running Windows 7 on PC.
0
votes
1answer
126 views

Converting firefox bookmarks to a database [closed]

I have more than 100,000 bookmarks in firefox. I want to save them in a contacts database so that I do not lose them and also easier to manage. The size of the html file is 55meg. How would I do ...
1
vote
0answers
84 views

Excel 2010 won't remember password when importing data

After connecting an Excel workbook with an SQL server (within a company network, over a static IP address, using the data connection wizard within Excel), if I close the workbook and reopen it, it ...
0
votes
1answer
50 views

Is it possible to manually edit/view KDE's Nepomuk database?

I'd like to know if there's a way to edit the content of the Nepomuk database, ideally with some simple tool. Some times ago I have recently the indexing of the email, in order to save system ...
1
vote
0answers
1k views

Libreoffice Base: How have a combobox linked to a related table linked to or in the form table control

I could not sum up, what I really want in the title. But here I am going to try to explain what is it about. I have switched from MS Access to Libreoffice Base because it is open source, free and ...
0
votes
0answers
72 views

Converting base64 encoded database

I have a dadabase whose structure is really simple. <ws> <e> <k>base64_encoded_string</k> <v>base64_encoded_string</v> </e> ...
0
votes
0answers
196 views

MySQL database on external encrypted hard drive

I want to move MySQL database installed on my "Windows 7 Enterprise" PC to an external hard drive which is PGP 2.0 encrypted. Could you please suggest how to do this?
0
votes
0answers
47 views

Stanford Wrangler ideal, but imposes limits, what are other options?

Stanford Wrangle tool is quite amazing, and I solved a giant problem with it, but it limits me to very small size. My file is about 500MB, and it allows me to process less than 1MB, the remaining data ...
1
vote
1answer
603 views

mysqldump not on wamp server

I am trying to use mysqldump on my wamp server mysql console however, it doesn't seem to have mysqldump included. I found the mysqldump.exe file in this location: ...
1
vote
0answers
307 views

Getting complement of two text files on the Unix command line

Is there a fast Unix-based utility (ideally written in C) for getting efficient, streaming intersection/union of tab-delimited text files? For example, allow queries such as "give me the all the ...
0
votes
3answers
684 views

Is there any disadvantage of vacuuming sqlite dbs?

Are there any disadvantages of vacuuming sqlite databases? If not, why don't applications vacuum their dbs?
1
vote
1answer
5k views
9
votes
5answers
7k views

Linux GUI Database Manager [closed]

Does anyone Know any KDE application for working with databases in a unified way? It must support several DBs (sqlite, MySQL, Oracle). GTK apps are also welcome :)
0
votes
6answers
20k views

Convert Excel Text string to Time

I'm trying to Export from an OLD System that stored Time in / Time out as a text string in 24 hour time. For example 3pm, is entered as 1500 (no colon) Is there a simple way I can convert these ...
0
votes
1answer
324 views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
2answers
532 views

Where to retrieve MySQL Database Backup? Centos 6

Had taken a look at: Where Are Databases Located - MySQL File Location Didn't seem to help much. I used this for a single MySQLDatabase backup: ...
1
vote
0answers
65 views

SQL Server - Database with strange storage space

I have a strange problem with one SQL server database: The database takes 180GBs on disk, with no space available; while the only table it contains should use only sth like 25GBs: EDIT: database ...
1
vote
3answers
920 views
0
votes
0answers
49 views

Deleting sentences in database file

I'm writing a MD5 based antivirus, and my friend send to me a document with thousands of samples and their MD5. All is fine, but I have to delete all sentences what contain "File does not exists:" ...
0
votes
0answers
205 views

Ubuntu FTP Server - Hetzner

I have an FTP Backup Server in Hetzner with details Backup Server: u*****.your-backup.de I am trying to connect to it through my ubuntu server using command $ ftp u*****.your-backup.de and i see ...
2
votes
1answer
5k views

automatically tag mp3 collection using shazam-like acoustic fingerprint

is there any software freely available to clean up the tags in your music collection , based on some sort of audio fingerprint type technology (like how 'shazam' app works on the iphone) combined with ...
3
votes
1answer
46 views

SQL Server 7 Transaction Logs Issues

Over the week my database server transaction log was full. With our app people could select from the database but could not update or insert into the database. In the past we have just truncated the ...
1
vote
1answer
287 views

How can I connect to an InterBase database using Excel?

There is an InterBase database that I'd like to connect to using Excel. I have the database name, address, and login info. IB, as I understand it, is a form of SQL. Using the SQL connect mode under ...
2
votes
1answer
2k views

how to connect to pervasive sql through odbc?

I am trying to add a linked server to a sql server 2012 database using ssms 2012. the linked server is pervasive sql. here's how i am trying to do it: EXEC sp_addlinkedserver @server = ...
0
votes
2answers
82 views

Is MyIsam safer than InnoDB?

Is MyIsam engine safer than InnoDB about loss of data due to FileSystem error? It seems that InnoDB is not reparable with MySQL tool. I had to choose my engine and I chose InnoDB because of foreign ...
3
votes
5answers
8k views

Free Mac OS X MySQL GUI [closed]

I'm looking for a good GUI app like Heidi SQL on windows for mac os x, snow leopard specifically. It can support more DBs than MySQL but needs to at least that. I'd like to be able to manipulate DBs, ...
1
vote
1answer
150 views

Which is better for multi-use auth, MySQL, PostgreSQL, or LDAP? [closed]

I want to set up an Oracle Linux 6 server that gives users secure IMAP email (with dovecot), Jabber IM, FTP (with vsftpd), and calDav. However, I want each user logon to be able to authenticate all ...
1
vote
0answers
50 views

Database for Quotes needed: Tags, multi-language support?

Dear superuser userbase! Almost every website now supports tags. I want to harness the power of tags for a private database, can you help? Ideal: A database of quotes (columns: English | German | ...
4
votes
3answers
778 views

How are sites like Pinterest able to hold all those pictures?

Does anyone know how sites hold massive numbers of pictures in general? I tried researching this, but it seems like they would need massive storage spaces to hold all these, unless there was a trick ...
-2
votes
1answer
266 views

Can I give access to database without access to cpanel

I'm going to give a freelancer access to the database. The idea was to give him the access with SSH (MySQL Workbench). But it came out that to do so, I would need to give him the password to my cpanel ...
1
vote
1answer
431 views

What does the output of this “source” command mean?

Unix newbie here, installing MYSQL. Per the directions from the server admin, I just added two lines to the end of my .cshrc file to create 2 new environment variables: setenv MYSQL_UNIX_PORT ...
2
votes
1answer
266 views

What's a good database-backed X.509 certificate authority on Linux

I've been using OpenSSL as an X.509 certificate authority. Because multiple machines will need to create certificates, I've exported the certificate authority folder on a distributed filesystem. When ...
1
vote
0answers
50 views

How to dump all MySQL databases for one specific user?

I need to export a particular user's databases so that they can take them to a different server. I have 30 or so users and many dozens of databases. This particular user alone has about 20 or so. ...
2
votes
1answer
3k views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
1
vote
1answer
112 views

Excel reference - connecting a list to a database

I am trying to create a database. I have 2 columns, if I enter a number in the first column, the matching name should appear in the second column automatically. The list of numbers and names is on a ...
1
vote
0answers
37 views

Visual Studio: Tables always added offscreen when editing EDMX files

I have a number of ASP.NET projects which utilise .edmx files to access tables on the relevant database for each app. If I add a new table, I have to open the .edmx and click Update Model from ...
2
votes
1answer
1k views

How to add new customized columns to windows 7 explorer (or find a similar application that is more customizable)

I like the way windows 7 explorer allows me to organize all my files by sorting columns - except there is little room for customization: I can't add my own types of columnns that can then be directly ...
1
vote
0answers
294 views

CDX currupt index file & Windows 2003 Server

We're experiencing almost everyday database index corruption on Windows Server 2003. I wonder if it can be somehow connected with caching or other server settings. We are running an old application ...
1
vote
1answer
72 views

Legacy BSD PTYs instead of /dev/pts?

I'm trying to use an old database that only accepts connections from legacy BSD style pseudo-terminals /dev/ttyp's or /dev/tty's. It does not recognise /dev/pts/9 style PTYs. Connections via SSH. I ...
2
votes
4answers
10k views

Where to store\update tnsnames.ora file when installed oracle client only?

I installed the oracle client only but was told to update my tnsnames.ora file with the info my dba sent me. But I don't have a tnsnames.ora file. On another machine with a full oracle admin install ...
1
vote
1answer
202 views
0
votes
3answers
498 views

Method to convert Zipcodes to Addresses

At my mother's workplace, she often accesses the database and pulls out numbers in order to form reports. From selecting data Oracle to outputting reports in Excel format, she has come across this ...
2
votes
0answers
52 views

Oracle Session Numbers Going Crazy - What is the best strategy to over come this issue?

We have a JVM web application which is running on Oracle Application Server and it uses commons-dbcp (http://commons.apache.org/proper/commons-dbcp/) and implicit connection pooling. Our db is Oracle. ...