Android, store a couple of wav files.
I'm generating about 6 wav audio files at runtime. I want to store them in internal memory. Is a blob to sqlite the right/recommended way? ...
database
What are advantages of using a one-to-one table relationship? (MySQL)
What are advantages of using a one-to-one table relationship as opposed to simply storing all the data in one table? I understand and make use of one-to-many, many-to-one, and many-to-many all the time, but implementing a one-to-one relationship seems like a tedious and unnecessary task, especially if you use naming conventions for relat...
How to securely communicate with a database using a java applet
I have been writing web applications for quite sometime in PHP with MySQL. I always stored my database connection information into a configuration variable and connected to the database that way. A client wants a java applet for their website to communicate with their database. I'm very hesitant on this because the applet is going to be...
Good DB Migrations for CakePHP?
Hi, I have been trying a few migration scripts for CakePHP but I ran into problems with all of the in some form or another. Please advice me on a migration option for Cake that you use live and know works. I'd like the following "features": -Support CakePHP 1.2(e.g. CakeDCs migrations will only be an option when 1.3 is stable and my ap...
Check how old an Oracle database is?
Hi all, So, we have a mirror of a santized version of the production database. Is there anyway (that you know of) to find out how old the database is? i.e. when the database was put on the Oracle server. Thanks for any help! ...
What would be better, (1 database + 4 tables) or (2 databases + 2 tables each) ?
Hi there, I would like to be advised on what would be better (in regards to performance) A) 1 DATABASE with 4 tables or B) 2 DATABASES (same server), each with 2 tables. The tables size and usage are more or less similar, so the 2 tables on Database 1 would be similar usage/size to the 2 tables on database 2 The tables could have...
Can we change the table or column name of aspnet membership?
Can we change the table or column name of aspnet membership. If yes? then what will be the effects ? ...
How can I integrate advanced computations into a database field?
My biological research involves the measurement of a cellular structure as it changes length throughout the course of observation (capturing images every minute for several hours). As my data sets have become larger I am trying to store them in an Access database, from which I would like to perform various queries about their changes in...
How do I convert a latitude/longitude pair into a PostGIS geography type?
I'm trying to load a bunch of latitude/longitude pairs into a PostGIS geography type so as to be able to query by location. In particular I have a table with float latitude and longitude columns and a geography(Point, 4326) column. I would like to do update mytable set geography = ??? The documentation appears to suggest that the fo...
SQL Select * from multiple tables
Using PHP/PDO/MySQL is it possible to use a wildcard for the columns when a select is done on multiple tables and the returned array keys are fully qualified to avoid column name clash? example: SELECT * from table1, table2; gives: Array keys are 'table1.id', 'table2.id', 'table1.name' etc. I tried "SELECT table1.*,table2.* ..." but...
How to use C# to parse a glossary into database?
This should be a simple one, but I'm a beginner with C#. Given a glossary list in the following format: aptitude ability, skill, gift, talent aqueous watery arguably maybe, perhaps, possibly, could be How can I parse this, and insert into a database table in the format: TABLE: Term_Glossary ==================================...
Application that modifies its underlying db schema
Under what circumstances (if any) would you allow an application to change its underlying database schema? I.e. to add new column. EDIT: A little bit of elaboration on what prompted me to ash this question. My system receives raport files from other systems and saves fetched data in "reports" table. Report includes several "parameters" ...
Does postgresql keep track of full table scans it makes?
I'd like to do something similar to what's described in http://www.bestbrains.dk/Blog/2010/03/25/HowToAssertThatYourSQLDoesNotDoFullTableScans.aspx but for that I'd need postgres to keep track of any full table scans it does. Is there such a thing for postgres? ...
Can I use NAnt to query my database and use the results as parameter values?
I spent 15 minutes searching the Task lists of NAnt and NAntContrib, and searching Google, but came up empty-handed. I want to send an email to every user of my system when I promote my code. I have a list of email addresses in my database, and I have a functioning email task. So, how can I connect the two? Thanks! D ...
Opening data connection
In c#.net when you open a connection to a database, in my case it's oracle, is there a lot of overhead involved? I'm guessing there isn't because of connection pooling. So am I correct in saying that everytime I open a connection it actually grabs an open connection out of the pool and if there are no available connections in the pool it...
How to force a refresh of possibly cached value?
I have the following Repository: Public Class PageRepository Private Shared _pages As BLL.PageCollection Shared Function AllPages() As BLL.PageCollection If _pages Is Nothing Then _pages = new BLL.PageCollection(LOADALL) Return _pages End Function End Class I do all selects using LINQ on the PageRepository...
How to bring coordination between file system and database?
I am working on a online file management project. We are storing references on the database (sql server) and files data on the on file system. We are facing a problem of coordination between file system and database while we are uploading a file and also in case of deleting a file. First we create a reference in the database or store f...
how to make Toad data modeler connect to my existing SQL server 2008 express?
Just installed Toad Data Modeler freeware and try to make a connection with my SQL Server Express 2008. Don't know how to do it. Anywhere has step by step instructions about how to connect a design tool to a database in Window? In the Data Source, do I need to define one for SQL Server? ...
Using a database in .NET
UPDATED QUESTION: Ok, I am going to simplify my question since I don't really know how to answer your questions. Say I create a new Windows Forms Application, then Project->Add New Item->Local Database. Then in Database Explorer I create a table ("testtable") and give it an "ID" column and "VALUE" column. Can you provide me with the ...
Linq insert statement inserts nothing, does not fail either
I am trying to insert a new account in my Acccounts table with linq. I tried using the EntityModel and Linq2Sql. I get no insert into my database nor an exception of any kind. public static Linq2SQLDataContext dataContext { get { return new Linq2SQLDataContext(); } } try { //EntityModel Accounts acc = Accounts.C...