database

Oracle problems in Rails with rake, but not with site

Hi guys, I'm working on a Rails site that connects to an Oracle database, and though I didn't build the site from scratch, I'm doing maintenance work. The site uses the delayed_jobs plugin to handle some background tasks and I'd like to be able to run rake jobs:work on the development server to periodically process all jobs in the queu...

MSI script to check sql server 2000 PE for a db name and not rerun db install script

Greetings, I am seeking help on building a script that will allow my msi installer to check for an exsisting db or exsisting user on the local server of sql server 2000 Personal Edition, during the pre install, the script needs to return the sql response and not run/resintall the sql scripts if the db name or db user is on the server al...

Simple Hello World Zend frameworks for PHP Script Required

According to Phpinfo Zend is installed (Zend Engine v2.1.0) . How ever when I call zend database commands they are swallowed without response or error message. (The script has been tested on my local server). I am looking for a "Zend hello world" php script which will tell me that Zend is running OK. Suggestions? ...

Are there Database Systems more suited to Social Networks?

This question is inspired by the article "Why are Facebook, Digg, and Twitter so hard to scale?" on highscalability.com So what database systems(however obscure) are out there that would be able to handle this type of data better? Thanks for you help! ...

Moving away from MS SQL Server to open source RDBMS

So I'm an MSSQL guy and I have been for a while because it's what I've always used in my workplaces. So when I create a new project I'm usually inclined to just grab a copy of SQL Express and start working from there. However, I've been asked to work on a new project but for various reasons, we can't use SQL Express edition and the lice...

Exporting Sqlite data from an Android Application

My Android application stores all user data in a Sqlite database. What are my options to backup/export/import/copy this data? I know I can easily copy the database to the SD card. I would also like to send the data to a network server. Are there any packages/classes available to facilitate getting sqlite information to/from a network...

Model from existing table in Rails 2

Hi! I have a database with tables. I want to create a model in my Rails app from existing table. As i know, such functionality is available, and is done as follows: script/generate scaffold model_name --skip-migration Of course, i defined my database in database.yml file. Scaffold generated for me a model with controller and views. My...

Why dont people simply use "Object Database"s ?

Instead of JDO , Hibernate , iBATIS why we can not simply use "Object DataBases" ? http://en.wikipedia.org/wiki/Comparison_of_object_database_management_systems ...

Best way to store enum values in database - String or Int

Hello there, I have a number of enums in my application which are used as property type in some classes. What is the best way to store these values in database, as String or Int? FYI, I will also be mapping these attribute types using fluent Nhibernate. Sample code: public enum ReportOutputFormat { DOCX, PDF, HTML } pub...

Best Java data structure to store a 3 column oracle table? 3 column array? or double map?

Hello :) What is the best data structure to store an oracle table that's about 140 rows by 3 columns. I was thinking about a multi dimensional array. By best I do not necessarily mean most efficient (but i'd be curious to know your opinions) since the program will run as a job with plenty of time to run but I do have some restrictions...

Enterprise Architect: Hide Foreign Key Labels in Database Diagram?

I am using Sparx Systems Enterprise Architect 7 Professional and I can not find a way to hide the labels from Foreign Keys Associations in Database Diagrams. Yes, I know I can right-click each of the connectors and use the "Set Visibility" option from the context menu but I guess there must be a per-diagram or golabal setting to do it. ...

Problem running scripts against SQL Server

We have some scripts that we run as part of our unit tests. This worked fine until today. We have tried running scripts with both windows and sql authentication. We have no problems logging in using sql manager Anybody have any ideas why we get the following error: Shared Memory Provider: No process is on the other end of the pip...

Should I normalize the intermediary model in django?

Say I have four pair-wise M2M related models: A, B, C, D. I have created an intermediary model ABCD to establish relationships between them. If there are many duplicate column pairs in the database, is it a normal practice to normalize the intermediary model into multiple models? What I am concerned about are: 1. Breaking down ABCD wil...

Get SUM of two columns linked to same column in different table

Hi I have a table "Events" for users to add events with the following fields: EventID EventName EventSlot (--> slotID) EventSlotExtra (--> slotID) (optional) EventLimit And I have another table "Slots" SlotID (int) SlotTime (this is 9am-10am, 10am-11am, etc) I need to query both tables so I can get a total of people attendin...

Setting Quercus db connection encoding to UTF-8 (urgent problem and need your great help)

Now we are going to use java class in my website developed with PHP + mySQL. I came to know Quercus and it worked well. But only problem is encoding. Quercus is providing ISO8859 encoding in default and all database in UTF-8 is not shown properly like ???. If anybody know the way to set Quercus db connection encoding to UTF-8, please he...

Query Oracle DB for timestamps when you know milliseconds

Hi, I'm currently getting the error: "java.sql.SQLException: ORA-01843: not a valid month" which I assume is to do with the way I am setting a timestamp... So I have a query like this : select * from A_TABLE where A_TIMESTAMP_COL < '1252944840000' But it doesn't work...and I don't want to have to convert it to a date ideally. Is the...

Determining DB in use from http query

Is there a simple way to determine what database is in use behind a website from an external HTTP request? i.e., I make an HTTP request, get back whatever data is going to come from the webserver - can I inspect any of that and reliably determine that DB in use? I am thinking not, but figured I would ask this group. ...

Managing a large collection of music.

I'd like to write my own music streaming web application for my personal use but I'm racking my brain on how to manage it. Existing music and their location's rarely change but are still capable of (fixing filename, ID3 tags, /The Chemical Brothers instead of /Chemical Brothers). How would the community manage all of these files? I ca...

Find new rows in database

I am looking for a way to know which rows in a database (mysql) are new (or updated) in order to fetch just those from the server and store locally in an application (client). My initial thought was to add a timestamp to each row and have my application remember the time it last got an update, however I am worried of the server clock c...

Free data warehousing systems--specifically, for data storage

I am building out some reporting stuff for our website (a decent sized site that gets several million pageviews a day), and am wondering if there are any good free/open source data warehousing systems out there. Specifically, I am looking for only something to store the data--I plan to build a custom front end/UI to it so that it shows ...