I am doing a school project where we need to create an android application which needs to connect to a database. the application needs to gain and store information for people's profiles on the database. But unfortunatly we are a little bit stuck at this point because there are numerous ways to link the application such as http request t...
My application is a non-relational database application with a tcl interface to retrieve data. I would like to add SQL programming interface to my application. Is there any library that converts SQL/PLSQL statements to API calls? It should also support stored procedures. SQLite(Embedded) has 'virtual table' mechanism that suits my req...
Is there an utility to convert mysql query in postgresql query ? ...
Hi community, I need some help with TimesTen DB query optimization. I made some measures with Java profiler and found the code section that takes most of the time (this code section executes the SQL query). What is strange that this query becomes expensive only for some specific input data. Here’s the example. We have two tables that ...
Hi friends, I have HostGator Baby Shared Plan . I develop Drupal site on. everything was fine at the beginning, then by the time i go further with development, site started ti work really slow. now it is not working at all. giving my sql errors like TOO many connections, etc... I created so many blocks, pages with View. so it makes my...
Hi, I'm working on a Django project where I need to provide a lot of different visualizations on the same data (for example average of a value for each month, for each year / for a location, etc...). I have been using an OLAP database once in college, and I thought that it would fit my needs, but it appears that it is much too heavy fo...
Hi All, I have one scenario in which the user can define the column and that can be the master table. This master table has transaction table by ref its Primary key and also has some common column whose value is differ for each record. Example, user created table called XYZ and defined the column X1,X2,X3 etc,. And the Transaction tabl...
Does System.Data.OracleClient support oracle 11g? If yes which version? The .Net appplication is presently running on 32bit server. We will be upgrading to 64 bit. Will System.Data.OracleClient support 64 bit too? Version of System.Data.OracleClient in use at present 2.0.0.0 with oracle 9i. ...
I've created an in memory hsqldb and am using the default database/schema. Now I want to drop and recreate the database programatically. How do I do that? Thanks Daniel ...
Okay, I am pretty sure at this point that this cannot be done, but here goes: I have a production SQL Server 2005 database with two filegroups, PRIMARY and SECONDARY. PRIMARY consists of about 2 gigs of typical database data. SECONDARY consists of 15 gigs of archived data that no longer changes. I would like to create a QA database in ...
I am planning on writing and commercialising a C# app which will store data in an underlying database I use MySQL on my environment for my own development and this is what I would have used to write the application for myself (no need to use FK - MyISAM engine would be fine). I am concerned about how easy it will be to distribute the ap...
I am venturing on making a website with a database for baseball games for an intramural league. I have made databases before, but this project seems to have many fields that will require at least 3 tables. I want to make the tables correct, so that I can sort and gather information from multiple fields properly ( such as the team table ...
There is a web application which is in production mode for 3 years or so by now. Historically, because of different reasons there was made a decision to use database-per customer installation. Now we came across the fact that now deployments are very slow. Should we ever consider moving all the databases back to single one to reduce en...
I am just switching from C to C# and would like to invest sometime learning database work. I am overwhelmed with the options: Linq-to-sql, ADO.NET. nHibernate, EntityFramework, plain old sql (I am used to this). Since I have only limited 'learning' hours available (about 2.5 hours per day), where should I invest my time? I don't want to...
I am trying to migrate a database, but I cannot find which database it is. The database files are like the following: FILE001.DAT FILE003.DAT FILE004.DAT . . FILE093.DAT FILEM02.DBT FILEM05.DBT . . . FILEM21.DBT SYMBOLS.IDX SYMBOLS.DAT There are .DAT, .IDX and DBT files. How can I read the data and database schema from these files; ...
Anyone knows any library for SQL Server database backup and restore for .NET? This actually is needed to avoid writing one new. There is so many people out there giving their libraries, but i found it strange i couldn't came up with googling anything related. ...
I need something real simple, that for some reason I am unable to accomplish up to this point. I have also been unable to Google the answer surprisingly. I need to number the entries in different tables uniquely. I am aware of AUTO INCREMENT in MySQL and that it will be involved. My situation would be as follows: If I had a table like ...
Is it possible to work with an encrypted SQLite database directly in Qt? Or, do I have to read it entirely into memory, decrypt in memory, do work, encrypt in memory, write to disk? ...
Hi, I'm a little confused, I'm developing a program, the program consist in two parts, the server and the clients, there are groups, places, messages... stored in the server, and the clients has to connect with it. I've design the use cases diagram, the activity diagrams, and I have design the class diagram too. The thing is that I want...
suppose I have a list of coordinates: data = [ [(10, 20), (100, 120), (0, 5), (50, 60)], [(13, 20), (300, 400), (100, 120), (51, 62)] ] and I want to take all tuples that either appear in each list in data, or any tuple that differs from all tuples in lists other than its own by 3 or less. How can I do this efficiently in Pyt...