I currently have a website with three builds: development, staging and production. Each of those has it's own MySQL database instance. Each of the instances has different data in it which should not change (orders). My question is, if I made changes to the structure of the development database, is there an easy way to propogate those ch...
Storing a telehone number in some kind of canonical format has several advantages from a programmers point of view, but it might confuse the user, if suddenly his entered numbers look a lot different. What's the way to go? ...
Hi all, I need to compact and repair an Access 2007 .accdb database file. I know that JRO.JetEngine can do this with .mdb files, but I need to repair the newer version 2007 format by code. Any suggestions? EDIT: Here is the thing: I found that I can use the COM object library "Microsoft Office 12 Access Database Engine Object Library...
Hello, I'm planning on writing a RSS Feed Aggregator with a team, but I'm wondering what XML Database we should use. The server currently runs IIS 6.0 with PHP 5.3.0 x64, I understand already that I need both a server application and a PHP extension. What I've discovered already: Galax Have previously used this at university, but I ...
Hi, using Grails 1.1.1 I have domain in Grails Person. Person can be related to another Person buut they can be stand alone. this is like: I have A as my friend and A have me as his friend B can be stand alone (not having friend) should I type Person { belongsTo = [friend:Person] hasMany = [persons:Person] constraints { ...
So like many people I want a way to download, index/extract information and store web pages efficiently. My first thought is to use MySQL and simply shove the pages in which would let me use FULLTEXT searches which would let me do ad hoc queries easily (in case I want to see if something exists and extract it/etc.). But of course perform...
Hi, QUESTION 1 - What .NET classes should I be looking at to help me read / update some data in a database, but assuming I'm not using LINQ or Entity Framework. That is if you drop back to the core .net framework what are the key classes to use. In particular something that lets me access data from table X via use of C#/object type ...
I have a Django model for Cat which has a foreign key Dog. The Dog model has a date key timestamp. I want to order the cats, using Cat.objects.order_by, according to the timestamps of their respective dogs. How do I do that? ...
i would like to query a MySql Database to show me all the existing databases based on provided condition (condition applied on the database name). now since my condition is complex, the simple "LIKE" condition is not enough, and i need to use the regular WHERE clause. can anyone provide a sample of how to do that? ...
We are using ASP.NET 3.5 and C# 3.0. According to the client's requirement, the database connection string need to be stored in system registry.During the connection establishment,we have to read the connection string from System Registry. How can i store connection string in System Registry? Using C# how can i programmatically read m...
Hello. I'm designing a DB and would like to know the best way to store this: I have an user table and let's say it can have 100 item slots, and I store an ID. Should I use JSON ({slot1:123232,slot20:123123123,slot82:23123}) or create 100+ fields (slot1, slot2, slotn)? Thank you. ...
I'd like to start an application that makes heavy use of a database, and is supposed to run on Windows under .NET as well as Mac/Linux under Mono. Having done some research, I've realised that neither LINQ-to-SQL nor LINQ-to-Entities are production-ready in Mono at the moment (here and here). According to the former link, LINQ-to-SQL ma...
Is there any way to select, for example, first 10 rows of a table in T-SQL (working MSSQL)? I think I saw something in Oracle defined as rownum meta variable, used in a following way select * from Users where rownum<=10 But what about MSSQL? ...
I hear a lot about couchdb, but after reading some documents about it, I still don't get why to use it and how. Could you clarify this mystery for me? ...
Hai, I'm developing a tool to synchronize SQL Server database with a Pi system (OleDb).Each time there is a change in the Pi System I need to update the values in Sql Server Database and vice-versa.Could you please provide me with the options possible and how it can be done. Thanks, M.K ...
I'm looking for Hibernate annotation or .hbm.xml that allows me to specify a table column as case-insensitive string working in unicode/utf-8/locale-independent manner that works on multiple database engines. Is there any such thing? So that I can do query using Restrictions.eq("column_name", "search_string") efficiently. ...
I'm looking for an open-source contact database application, preferably written in PHP5. Anyone know of a good one? I'm not looking for a full-blown CRM system, just something with a contact entry form, a backend for adding/removing contacts and maybe even a search system. thanks! ...
Have full text index on a table for the purpose of searching and producing a list of results based on relevance, I assign relevance based on the highest "score" from the full text index. The table contains 3 columns, a unique ID, a text field in the type (varchar), and the third is a timestamp of the last edit. The full text index only ...
Hi, I have a table in MySQL 5 (InnoDB) that is used as a daemon Processing Queue, thus it is being accessed very often. It is typical to have around 250 000 records inserted per day. When I select records to be processed, they are read using a FOR UPDATE query to eliminate race conditions (everything is Transaction Based). Now I am dev...
in my query i have IF(friend.block, 'yes', 'no') and friend.block value is 0 or 1.. but eaither way its putting 'yes'.. any idea? ...