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)

0
votes
0answers
2 views

Setup Snort on mac with Postgresql 9.4.1: createuser: could not connect to database postgres: FATAL: role “_postgres” does not exist

Trying to setup snort on mac os x Yosemite(10.10.2) with Postgres 9.4.1(installed with Homebrew) I have no experience working with Postgres But trying to learn a little... So I've done this before: ...
0
votes
0answers
8 views

NoSQL key-value based schema for building a quick lookup hotel room reservation system [on hold]

I am building a hotel room reservation system which will expose 2 APIs to my clients - hasVacancy(...) and reserveRooms(...). I am thinking of using a NoSQL key-value datastore. The number of requests ...
1
vote
1answer
33 views

How to convert a FoxPro database without spending $$$ [on hold]

Got an old piece of software that I need to pull the database out of, so it can be easily moved to some new software. Based on the information I have found so far, I believe it is a FoxPro database ...
-1
votes
0answers
16 views

Modify Excel data connection without disconnecting the connection file

I have several workbooks which connect to the same SQL server data source. I would like to store the details of the data source in a file in a central location, so that if the database is moved to a ...
-1
votes
1answer
41 views

.mdb file completely corrupt after the frequent recoveries

I am running Access database and one of .mdb files was corrupted for a long time. I got an error messages repeatedly, unfortunately I don’t remember exactly which ones. I let it go because I was still ...
0
votes
1answer
27 views

Performance comparison for older server [closed]

Given the falling price of older decommissioned server hardware, I am considering purchasing one to use for my research at home. I will be running Linux, PostgreSQL, Neo4j and R-Server on it. I ...
1
vote
2answers
40 views

Access database error: The module name xxx is misspelled or refers to a module that doesn't exist

We are using Access database 2003 (I know, too old) with Win server 2008 in my company. We have one .mdb file split into two. A couple of days ago we had a problem trying to open modules. It all ...
0
votes
0answers
22 views

Strip non-numeric characters from a phone number in spreadsheet

I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example: (123)456-7890 fred ...
0
votes
0answers
10 views

Alligning Two data sets - one data set has duplicates

How can I align two data sets so that one data set spaces out to match the other. For Example I have two Data Sets: DATA SET A DATASET B Individual ID Household ID ...
0
votes
0answers
16 views

The LDAP Server is unwilling to perform (53)

I know the problem is not new, but I'm trying to get this server work at least one week. The steps I did. Install OpenLDAP Importing all ldif (It was working). ls /etc/ldap/schema/*.ldif | xargs ...
-1
votes
0answers
31 views

Poor MSSQL server performance on virtual machine after system upgrade

I'm managing middle sized company database. Recently we have massive system upgrade and switched to virtual machine environment. After deployment, we are having performance issues, Apparently MS SQL ...
-1
votes
0answers
41 views

How to drop whole tables in a database using batch script ( Windows)

I would like to know how to drop the whole tables in mysql database using batch script. I've already searched on how to do this in linux and this is what i've found: mysqldump -u$User -p$Pass ...
-3
votes
1answer
20 views

sql database errors 823. Can someone help me? [closed]

I have a question….How to fix sql database when generating an errors 823? Please help me to out this! Thanks
1
vote
3answers
52 views

Can a database be too relational?

I have a question about database design. I'm asking here because I'm an enthusiast/hobbyist and not a "professional" so I don't want to post it on the "Database Administrators" stack exchange ...
2
votes
1answer
20 views

Connecting to host OS database from guest OS VirtualBox virtual machine

I’m using Pentaho BI server in a CentOS VirtualBox machine, and now I want to connect it to an SQL Server database that I am running in my Windows host OS (localhost). Is there a simple way to do ...
0
votes
0answers
11 views

How to Create a VirtualBox like Oracle developer day VM using CentOs?

Oracle has provided us a way to use Oracle Database on Mac with its Developer day VM's. But its of huge size and I couldn't resume the download. So I want to build a VM with Oracle Database installed. ...
0
votes
1answer
95 views

Apache couldn't be started because port 8888 is in use by some other software

I am having an issue starting up MAMP, when I attemp it, I get this error message: Apache couldn't be started because port 8888 is in use by some other software I have been trying for the last 2 ...
0
votes
0answers
9 views

How to backup and migrate only the user account data of one Gitlab server to another?

So we have 1 Gitlab server that we've outgrown so I am expanding to a second one for all new repositories but keeping the old one for existing repos. Our userbase is the same but I don't want to go ...
0
votes
1answer
12 views

cumulative profit of each client in table no 2 from data of table 1

I want cumulative profit of each client in table no 2 from data of table 1 formula i use is ...
0
votes
0answers
16 views

How do I create a new database?

Since upgrading to Yosemite 10.10.1, I can't create a new database set theOutputFolder to choose folder with prompt "Please select an output folder:" tell application "Database Events" make new ...
0
votes
0answers
24 views

what permissions are needed to run a jar file on a shared drive

I want to run an executable jar file from a workstation that accesses the file from a shared drive on a network server. The program accesses a local database on the server and if accessed directly on ...
1
vote
0answers
134 views

How to recover MySQL database on xampp/windows using ib/frm files?

I'm using xampp on Windows 7. Couple of tables of my Wordpress database got corrupted. When I view the database in phpmyadmin, the tables have the message "in use". I tried ...
0
votes
0answers
10 views

Copy SQL Server database with full transaction log

I have full SQL server transaction log on one server and one database (full recovery model) that I unfortunately don't have direct access to the database. Something in the software is filling up the ...
1
vote
1answer
63 views

Inserting Crackstation's Wordlist into a database table

I'm trying to insert Crackstation's 1.5 billion wordlist (15gig) into a database table. I've tried SQLite and Postgres both with no luck so far via the command line. Both get upset that the data ...
0
votes
1answer
23 views

Reads vs Writes

Consider a Database which is being constantly accessed (read,write,update,deletions etc) , for instance the Database for some particular airlines. I can understand simultaneous writes/updates can ...
-1
votes
2answers
33 views

The “smart” way to crawl the web [closed]

I have a project in which I have to crawl the web for lyrics, I am implementing depth-first search and I am making a database in a list (which contains nested lists which will later be saved in a ...
-1
votes
1answer
78 views

I want to install and configure MySQL Server silently with remote access

How NSIS MySql Silent install and configure to enable remote machine access. **ExecWait "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqlinstanceconfig.exe -i -q ServiceName=MySQL RootPassword=root ...
13
votes
2answers
330 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 ...
0
votes
0answers
7 views

SquirrelSQL does not display schema owned by another user (Postgres)

I've noticed that SquirrelSQL (v3.6) does not display schemas in a Postgres (v9.2) database if it is owned by another user, even if I'm connected to the database on superuser. When I do alter schema ...
0
votes
1answer
193 views

phpMyAdmin used by java application

I have a MySQL database running at a site using phpMyAdmin. My problem is that I want to use this database inside a Java application which runs as a regular, non browser, application. The problem is ...
0
votes
0answers
23 views

Hide a Database in a .jpg picture [duplicate]

Is there any way to put a database in a picture with a command prompt only (like copy /b 1.db+2.jpg 3.jpg) but keep the Database and the Image intact? I dont want to use any software. I want put my ...
-1
votes
0answers
20 views

Access Database button is not working properly [closed]

I work with a company that works with several older access databases. The databases work when opening them using Access 2007, but when I try to open them in Access 2010, all of the buttons work in ...
0
votes
0answers
33 views

Dumping an SQLite database stored as dll file?

A little background first: I need to extract a database from an SQLite dll file for my client who has burned bridges with the previous dev. I have these 4 files sitting on my desktop: ...
1
vote
1answer
32 views

Host a database server with a different hosting company [closed]

I am hosting my app and database in Linode. I want to scale it by having a separate database server, but I reckon I don't need to pay $10/month for another VPS with Linode for the database server. I ...
0
votes
2answers
29 views

Data modelling, calculation and visualization tools?

I often need to make decisions based on various kinds of data and their calculation results/visualizations respectively. For simple, tabular data I usually make Excel spreadsheets, however most of the ...
0
votes
0answers
19 views

OBDC SQL connector for Windows Auditing Server to interface with Linux syslog server

I am working on a cross platform project here is the scenario: UNIX/Linux We have a Linux syslog server currently in place collecting syslogs from all network appliances and UNIX/Linux systems. ...
0
votes
0answers
31 views

Why is it not recommended to use zero in an ID column in MySQL?

If you're building out a project from scratch, what are some reasons that one would not recommend using zero (0) in an id column for MySQL? Assuming that the MySQL database/server is in strict mode ...
0
votes
2answers
73 views

Shortening an Excel formula if possible

I am unable to shorten an Excel formula I am using in an Excel database. I have googled it, but this appears to be the shortest way already from the first page on Google. ...
3
votes
1answer
42 views

Index files and folders in windows

I want to create a database of all files and folders within a specific location (say, E:\movies). How can I do this? Is there any software which can do this for me? Otherwise do I need to write code ...
1
vote
1answer
65 views

Excel - auto-fill blank cells or 0 in B:B to a dummy e-mail address which changes sequentially

I am creating a database in Excel that requires an e-mail address to be assigned to each row or user. While some users have an e-mail address in the original CSV file the majority do not. Each e-mail ...
0
votes
0answers
10 views

Eclipse plugin for viewing database scheme

I tryed to install following plugin: dbschemaviewer but it doesn't work for me. I see following message: I think that it is related with version incompatibility. Can you advice alternative plugin ...
1
vote
0answers
56 views

How to fix botched Outlook CSV data export 2013

When I exported contacts from outlook into a CSV file (to later upload it to Insightly database), it placed company names as part of the email address, it looks like this: Column named "E-mail" ...
0
votes
0answers
8 views

IDEA bad encoding inside database veiw

I have connected my database and IDEA. Now I see list of tables from my database. but when I want to see table content I see following: Actually this content on my native language(not English). ...
2
votes
0answers
192 views

How to use ShemaSpyGui for view database diagram

I installed Postgre today and I want to watch database shema. I resolvse to use schemaSpy and download it and also schemaSpyGui and then I see: This is the command (password not displayed!) ...
0
votes
0answers
207 views

OpenFire connect to SQL Server Database: Network error IOException: Connection refused

I am trying to get OpenFire to run with my SQL Server. I am following the instructions at Instructions. I have created a new database, named it OpenFireDB, and have created a new login and user, both ...
-2
votes
1answer
49 views

How does social media sites store posts [closed]

Do social media sites such as Facebook and twitter, store posts in a database? Like mysql? Wouldn't the database be extremely large? Does Facebook or social media sites remove old post?
0
votes
0answers
19 views

Extending an formula over multiple cells

I want to set up an excel table where: A:A is my 1st data table B:B is my result table C:C is my "Column" table D:D is my "Row" table E:E is my 2nd data table I want the result of the function to ...
0
votes
1answer
221 views

Photo Organizer that works from many computers to one file server

I have a file server in the closet. It runs Ubuntu, and exports my photo library as NFS4 and SMB. I have children and a wife who all also want access to these photos. Right now, the archive has the ...
0
votes
1answer
75 views

Are Intel i7 core mobile processors decent enough for software development? [closed]

I'm reaching out because I'm in the market for a new laptop, and I would like something light that I can take with me for a job interview or meet clients, so I can demonstrate my source code and ...
0
votes
0answers
50 views

Recover back end database password from front end connection string

I built an MS Access database about a year ago and set separate passwords for the "front end" and "back end" components of the database. It's been a long time since I've had to access the back end ...