We have quite a bit of logic in TSQL stored procedures. Being a big fan of automated tests, I started writing automated tests for stored procedures. I test stored procedures by calling them from a C# project. I make all tests touching the database inherit from a base class the ensures the test is run in a TransactionScope that is neve...
I have a JPA/Hibernate data model that I am using the Hibernate hbm2ddl tool to generate database DDL. I have some strings that should be CHAR and some that may be VARCHAR in the database. I want to minimize hand editing of the DDL (I realize that some will have to happen). Anyone know how I should go about this? I realize that I can ma...
I am learning about the Apache Cassandra database [sic]. Does anyone have any good/bad experiences with deploying Cassandra to less than dedicated hardware like the offerings of Linode or Slicehost? I think Cassandra would be a great way to scale a web service easily to meet read/write/request load... just add another Linode running...
It is often said that using LDAP is a good way to store data about users. That's beacause users' "directory" is hierarchical and it changes rarely. But in my opinion that doesn't exclude using RDBMS. What might be reasons to use LDAP? I guess that storing multi-valued fields or adding custom fields in LDAP might be easier but it can be d...
I have the following tables in MySQL server: Companies: - UID (unique) - NAME - other relevant data Offices: - UID (unique) - CompanyID - ExternalID - other data Employees: - UID (unique) - OfficeID - ExternalID - other data In each one of them the UID is unique identifier, created by the database. There are foreign keys to ensure ...
Hi What are the best resources free download(websites/webservice) to get/read foreign exchange(currency convertion) information directly to my application. data can be excel,.axf,csv,xml. I would like to know the possibility of reading from direct website/webservice to ssis components as well Thanks, ...
I'm having difficulty modifying a postgres user that contains a dash in its name - I've run into this problem several times, but can never find the answer (no matter how much googling I do!). osm=# grant all on osm_polygon_view to www-data; ERROR: syntax error at or near "-" LINE 1: grant all on osm_polygon_view to www-dat...
I am coding a E-commerce website/admin interface for a client. They are doing some B2B so they want the cart to be saved/loaded from database so if the user close his browser and reopen it the cart is intact. The application is using the Zend Framework and I've been looking to the Zend_Session_SaveHandler_DbTable. So I can save the ses...
I'm parsing a xml file and inserting it into database. However since some text containes double or single quotation I'm having problem with insertion. Currently I'm using the code shown below. But it seems it's inefficient. s = s.replace('"', ' ') s = s.replace("'", ' ') Is there any way I can insert text without replacing these quota...
I have inherited a mysql schema with around two dozen tables. I would like to create an E-R diagram (or some form of visual representation) from my the create table statements. I am looking for free open source tools which will help me do this. This will help me understand the schema better and aid others as well. Do people have experi...
I'm in the process of creating a social network. It has several entities like news, photo, which can have comments. Since all comments have the same columns and behave the same way, and the only difference is their type — news, or photo, or something else to be added in the future — I decided to create one table for all comments with a c...
My web app deals with polls (surveys). Right now I have 2 tables as part of database schema. polls id question choices (ex: yes,no,maybe) created polls_responses poll_id user_id tracker_id response The problem with this is that on some polls I have alot of responses (>1000). People can view the resul...
Hi I really hope someone can help me with this. I'm struggling with it for nearly two days now... I have a DB-table "Device" and a table "Connection". I'm using it to visualize my company's network. To pass the data to the JS-framework I use to visualize the data I need an array like this: Array ( [id] => 1 [name] => TestPC1 ...
Suppose you have an database with the largest tables containing about 200.000 rows, and frequently modified. The client wants Excel to connect via ODBC to the database, and work as a frontend to manage the data. The data should be modifiable by up to 25 users concurrently. My first instinct would be to recommend something else, for exa...
Hi, I'm having a little bit of trouble saving data to a database. Basically, I have a main table that has associations to other tables (Example Below). Tbl_Listing ID UserID - Associated to ID in User Table CategoryID - Associated to ID in Category Table LevelID - Associated to ID in Level Table. Name Address Normally, it's easy fo...
i have stored values in mysql and i want to retrive that value in webpage but the webpage is creted only using javascript so how can i use that database's value in javascript ...
This is a design problem I face regularly and I'd like to find some general insights about the subject. The code provided here is just an example. In the design phase it's easy to decide you need an object: User ========== Unique ID Login name Password Full name And it's easy to convert it into a database object: CREATE TABLE user (...
Hello, I have a table called enterprise in my database. If the entreprise expresses its demand to my company, the enterprise will become our prospection. And after, if the enterprise accept my company's proposal, we will sign the contract, and enterprise becomes out client. Now, i have created 3 tables which are enterprise, prospectio...
Hi I'm using modx on a site but somthing has gone wrong with the database. Any idea how do I can change the php to point to my database? Thanks for your help Regards Judi « MODx Parse Error » MODx encountered the following error while attempting to parse the requested resource: « PHP Parse Error » PHP error debug Error: mysql_conn...
preferably open source for storing tick info. ...