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)

27
votes
5answers
29k views

“FATAL: lock file ”postmaster.pid“ already exists”

I just reinstalled postgres via brew install postgres I ran initdb /usr/local/var/postgres -E utf8 but got this: The files belonging to this database system will be owned by user "atal421". This ...
22
votes
4answers
64k views

Sync Two MySQL Databases

What is a good way to sync two MySQL databases? I would like to sync the data in my production website's database to my local development database. Right now, I am just using the PHPMyAdmin ...
22
votes
4answers
33k views

How to export mysql schema from phpmyadmin?

I have a huge db that hangs the server if I try to export it, is there a way I can export it without all the data? Only the tables structure.
19
votes
2answers
19k views

create mysql database with one line in bash

Is it possible to create an empty database with one line of command in bash? My newbie attempts have failed: mysql -uroot $(create database mydatabase;) I end up having to mysql -uroot create ...
17
votes
1answer
50k views

How to: Database Model in Visio 2013

I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
15
votes
3answers
1k views

What happened to WinFS?

The most interesting feature that was ever connected to what eventually became Vista was WinFS, a revolutionary (so it seemed, at least back then) new way of storing and accessing information on a ...
12
votes
2answers
414 views

Can a file system's logical structure (including symlink targets) be represented in a single lightweight file (non-binary)?

After playing with multiple SQL and NoSQL databases over the years I feel the best way for me to ensure portability in my personal apps that are data-centric is to avoid all bonafide databases ...
10
votes
3answers
12k views

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

I had some problems with my RAM (bluescreen several times, Windows XP) and now are my Firefox databases damaged. Firefox is working, but my history is gone and it's reporting several inconsistencies ...
9
votes
3answers
17k views

Where can I find H2 JDBC driver?

http://www.h2database.com/html/download.html I don't see it on this website. Is there anything I missed?
9
votes
4answers
8k 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 :)
9
votes
3answers
7k views

What file format/database format does Picasa use?

I am trying to figure out what file format the .db file and .pmp files are. I tried using db_dump (Berkeley DB) for the .db files, but it seems that they are not Berkeley DB, or of an older version. I ...
8
votes
1answer
18k views

What is a DDL script in the context of databases?

What is a DDL script in the context of databases?
8
votes
7answers
913 views

School Management System

I am looking for a school management system to replace a homegrown Access db. It should be able handle the following for both a Primary and Secondary school Scheduling classes Student ...
7
votes
5answers
10k views

What FLOSS DB design tool for Linux would you recommend?

I want to find a relational DB design tool for Linux, that could export DB schema for MySQL, SQLite and PostreSQL at least. And it should be handy, of course. Good-looking GUI is also a plus ;-) I use ...
7
votes
2answers
6k views

PowerShell zip file synchronously

In a PowerShell script, I want to zip a folder before deleting the folder. I run the following (I don't remember where I found the snippet): function Compress-ToZip { param([string]$zipfilename) ...
7
votes
4answers
570 views

I'm managing SQLite, MySQL and PostgreSQL databases and want a tool for this locally

I develop web applications on Mac OSX in SQLite, MySQL and PostgreSQL and these are then put on the webserver. I want to be able to take the brunt out of looking at the terminal locally when dealing ...
6
votes
5answers
2k views

Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm

I'm trying to develop an Excel formula that would calculate the actual time duration for a string of a time range of the following format: 1:00am – 3:00am According to this article it seems it should ...
6
votes
2answers
5k views

Excel: How to connect to a sqlserver localDB

I have created a LocalDB that I can work with in MS sqlserver management studio 2014, linqpad, and visual studio 2013. Here is the part of the "connection property" dialog in SSMS which shows the ...
5
votes
2answers
10k 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 ...
5
votes
1answer
4k views

Cleared vs. Unformatted partition in GParted

I am running a database-like application that writes and reads data directly to and from a raw block device. I would like to create a new partition for this purpose, and I am using GParted. I've ...
5
votes
4answers
8k views

Tool for automatically generating and laying out an entity relationship diagram?

I've seen a lot of tools which can reverse engineer an ERD from an existing database, but I haven't been able to find one which is capable of automatically laying out the diagram in a reasonable way. ...
5
votes
2answers
684 views

SQL Server Management Studio ignores default DB

When I use SQL Server Management Studio to log in to databases, it ignores my default DB and always puts me in master. I checked that my Windows user has a login with the correct DB set, and I tried ...
5
votes
4answers
12k views

How do I synchronize multiple Access Databases together?

I'm conducting a study, where we will be collecting data using Access. Since there will be multiple persons conducting these studies using the same structured Access DB we need to figure a way to ...
5
votes
3answers
5k views

How does geolocation based on IP address work?

As all Internet users, I've visited web sites which appear to know in which country and city I'm located. I understand that these web sites typically look up my IP address in a database which maps IP ...
4
votes
4answers
15k views

What's the equivalent of Microsoft Access on the Mac?

I want to use a Microsoft Access 2007 database on my Mac. However, it appears that Office 2008 for Mac does not have an equivalent to Microsoft Access. I'm new the Mac so can anybody suggest a easy to ...
4
votes
3answers
1k 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 ...
4
votes
2answers
16k views

How do I configure ODBC DSNs in Windows Server 2003 and Windows 7?

I haven't done this in quite a while, but years ago I have set up DSNs for an ODBC connection using Windows 2000 and maybe Windows XP. I remember there being a Data Sources or ODBC icon to click in ...
4
votes
2answers
5k views

Can I restrict users from design view in Access 2003?

Can I prevent users from opening an access 2003 database in design view? I don't want others to be able to change structure of the tables, just add change or delete the records within the table.
4
votes
2answers
2k views

To have Vim Psql's editor

I have a Fresh Ubuntu installation. I have no personal dot-files active. I run unsuccessfully \e file.sql in Psql, when I have the following in my .bashrc, since Nano opens instead of Vim export ...
4
votes
3answers
178 views

How do I force an application to recognise two names for a disk drive?

I have an extensive image database (3.25GB metadata, 90K images) held in a legacy product (idImager V5). This in turn utilises SQL Server 2005 as the underlying DBMS. Over time, I have been adding ...
4
votes
1answer
7k views

How to display text in UTF8 from mysql /phpmyadmin?

I have a database with multiple tables. The database and table and every row of table is set to utf8_romanian_ci. Every name which I import that contains diacritics will not be displayed correctly. ...
4
votes
1answer
93 views

How to store processed data?

I'm working on a project involving Twitter data. I have several hundreds thousand tweets downloaded and stored in files. The data was returned in json format, and the stream consumer I was using ...
4
votes
1answer
126 views

What software should I use to display an elegant looking take-out menu on an HDTV monitor? (data pulled from local MySQL server)

My mom owns a small take-and-bake market, and she's been keeping her menu and inventory on an ugly and messy set of whiteboards behind the counter. I've developed a database that lets her check ...
4
votes
1answer
953 views

Read data from separate CSV file in OpenOffice Calc

I have a very large CSV file (many thousands of rows) that I want to work with. Due to the size of the file, I don't want to import it into openoffice. Rather, I want to create a spreadsheet that ...
4
votes
1answer
452 views

MySQL quiet installation references wrong executable

I am trying to install MySQL 5.5.27 (latest) quietly from the Windows (XP) command line via batch file using the MSI method. Following the directions on the MySQL site, I simply do this: msiexec /i /...
4
votes
0answers
1k views

Free Tool to Generate Diagram of SQLite Database

I tried using openoffice via ODBC, and it connected properly, but when I tried to use tools->Relationships... , it gave me the error message "The database does not support relations." I'm using OOo 2....
3
votes
5answers
10k 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, ...
3
votes
7answers
2k views

Small database for scientific papers

What small database for scientific papers can be recommended? I just need a small way of handling a list of a few hundred (maybe 300 tops) scientific papers. I have author (often more than one on one ...
3
votes
2answers
2k views

How can I keep every fifth row in Excel

I have a data set in excel with 3084 rows. I need to delete 4 rows, then keep one: deleting Tuesday, Wednesday, Thursday, Friday but keeping Monday to create a weekly rather than daily data set. ...
3
votes
4answers
949 views

Is there a GUI interface for sqlite? [closed]

Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
3
votes
5answers
622 views

Flexible database software recommendation [closed]

I'm a surgeon, just starting my career. I'm hoping / planning to accumulate a 30-year dataset of surgical patients, with one or several procedures associated with each patient. Each procedure will ...
3
votes
2answers
27k views

Dynamically filtering data before importing from SQL Server in Excel

I'm trying to figure out whether there is a way to filter the data from an SQL Server connection before it is imported into Excel. The initial import doesn't matter (when the connection is set up), ...
3
votes
2answers
1k views

Where Are Databases Located - MySQL File Location

I just installed a CRM application with a MySQL database. I thought I new the name of the database but I can't find it. Now I am trying to perform a mysqldump but I don't know the name of my ...
3
votes
4answers
756 views

QnA Knowledge base software [closed]

I'm looking for a small software to build a knowledge base of QnA's on my local PC, like the KBs large software vendors maintain for how-to's regarding their products. Something where I can: Q: ...
3
votes
4answers
1k views

Is there an online alternative for picasa? [closed]

Is there an installable PHP/MySQL image database system like Picasa? I want to setup a small image database for our company. It would be hosted online, so the co-workers have access from any place. I ...
3
votes
2answers
22 views

SQL : Restrict view of tables in database

This is probably a no but, I want to be sure. A client wants to connect to SQL Server 2008 that we host. They will be accessing a table to execute an SSIS package to copy some data they have on their ...
3
votes
2answers
5k views

What's the difference between .db and .sqlite files?

I had a look into a program's folder in Program Files of the Windows directory and I found that it has a lot of files with .db extension. I opened one with notepad and I saw that the first string in ...
3
votes
1answer
5k views

Returning a range of rows in DB2 (LIMIT X,Y equivalent)

Im working with DB2 and I need to be able to return a limited set of results. Ive figured out how to return the "TOP n" results with "FETCH FIRST n ROWS ONLY" But I cannot figure out how to get rows ...
3
votes
2answers
3k views

Can I use SQL to build an Excel data table from other Excel files?

I know SQL well enough to perform basic queries and manipulate data split into multiple tables in a database. I know Excel 2007 a bit better and use it frequently to manage my mechanical engineering ...
3
votes
5answers
1k views

Is there a better way to organize my downloads?

I'm a download pack-rat and have a large collection of downloaded files including software, music, videos, books, magazines and research papers. I'm looking for a better way to manage all of it. ...