Hello, there's this interesting problem i can not solve myself. I will be very glad, if you help me. Here's it: there are many client applications that send data records to one MySQL server. Few data records are not very important, but the whole database is. (You can imagine it is facebook DB :) ) Is there any way to ensure that data f...
I've a database with 3 of the tables having rows in excess of 20 million each. I've used GUIDs as primary keys (unfortunately). Now our database is about 20GB and growing 5GB per month. It takes about 2 hrs to take full backup of the database, and 30hrs to restore on a box with 4GB RAM. We once have all the tables from database disappe...
Here is the context : I have database A on one server, which is used from internal production. And database B on another server which provide some of the database A's information to a web site. A is updated internally, and B can is updated by the website's client. What is the best solution to keep an intégrity between both database? ...
Hello, is there any way to execute multiple statements (none of which will have to return anything) on Firebird? Like importing a SQL file and executing it. I've been looking for a while and couldn't find anything for this. ...
So the application we've got calls the API's of all the major carriers (UPS, FedEx, etc) for tracking data. We save the most recent version of the XML feed we get from them in a TEXT field in a table in our database. We really hardly ever (read, never so far) access that data, but have it "just in case." It adds quite a bit of additio...
I'm working on a mobile device with a sdf database. I'm wondering if there's a quick easy way to export the table to CSV. Currently the c++ application opens the tables, and walks through it one record at a time and one field at a time, appending to a file. It's ugly and slow and predates my employment. I'm wondering if there is a bet...
hi what the difference between not in - and - not exists in oracle query ? when i use not in and when i use not exist ? thank's in advance ...
If I can open a connection to an MS Access file in C#, how can I retrieve a list of the different tables that exist in the Access DB (and if possible, any meta-data associated with the tables)? ...
I'm using the Publish to Provider option in my SQL Project in Visual Studio 2008. I only check the box to script stored procedures leaving all others unchecked, yet the script produced includes all objects. Why is this and how do I stop it? Cheers, Breandán ...
Related to a question I asked earlier here, I've found a problem which is eluding me (obviously). The original question was how to select a min and max date from a daily table based on a monthly table where some daily table dates could be missing. Basically what I needed was columns containing the month date (always the first), the earl...
Guys which Database is Support apple iphone application and is Database similar to Oracle and Sql etc.., Let me know About Apple iphone database . please give me any example appliccation to know the process .. how to connect Application to DataBase for instance i have a USername , Password and there is a Submit Button , when i hit the...
I understand that the database log feature is supported in 3.3 version and not released in 3.4 is there any way I can use the database feature in 3.4 ...
My doc has an array field Keys Keys1 and Keys2 are two arrays I want all the docs where Keys contains any value in Keys1 AND any value in Keys2 Any advice? Thanks ...
Hello, I want to only grab the last post of all topics in a category (Category->Forum->Topic->Post) from a phpbb database in a single query. Currently I have cooked up this, but it returns only the first post, not the last. SELECT *, MAX(p.post_id) FROM phpbb_forums f, phpbb_topics t, phpbb_posts p WHERE f.parent_id IN (<categories>) A...
We have multi GB files coming every day to be loaded to SQL Server 2005 instance via SSIS packages. To load those large data files to SQL Server asynchronously, we built multi threaded .NET application. This application uses DTSExec command line executable to invoke SSIS packages. It also instantiate 5 queues and 5 streams for each queue...
For example, I have a table, and there is a column named 'Tags'. I want to know if value 'programming' exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new OleDbCommand("SELECT * FROM table1 WHERE Tags='programming'", conn); OleDbDataReader = cmd.ExecuteReader(); What should I do next? ...
I'm doing maintenance work on an existing Rails site and am having some problems stemming from many-to-many associations. It looks like the site was initially built using has_and_belongs_to_many for a few relationships that have since gotten more complicated in the business logic, so I need to use has_many :through instead to support ad...
I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the tables are in the same database, then everything works fine. ...
I need to store some diffs of other tables' columns in the database. I want to use a single table. Option A Table with 4 columns: id content_type (VARCHAR 255, will be: datetime, integer, varchar, text/clob ...) old_content (CLOB / TEXT, software serialized data for content-type) new_content (CLOB / TEXT, software serialized data for...
I am trying to switch between 2 mysql servers at runtime. I do not need to maintain both connections alive all the time. This is what I am doing from django.conf import settings from django.db import connection from django.contrib.auth.models import User connection.close() setattr(settings, 'DATABASE_HOST', 'mysql1.com') list1 = User....