I want to create a a application in actionscipt 3.0 that allows the user to listen to music and read descriptions of the music. For this to happen i suppose there should be a database where the textbits and music is located and then flash fetch the info when the correct buttons are pushed. The database will contain up to 100 tracks and t...
When SHOW WARNINGS after a EXPLAIN EXTENDED shows a Note 1276 Field or reference 'test.foo.bar' of SELECT #2 was resolved in SELECT #1 what exactly does that mean and what impact does it have? In my case it prevents mysql from using what seems to be a perfectly good index. But it's not about fixing that specific query (as it is an irr...
Hello, I have an application where I'll have repeating events. So an event can repeat by day, "every n days", by week, "every n weeks on Mon/Tue/Wed/etc", and by month, "every n months on the 1st,2nd,3rd,etc". What is the best way to handle this from a table design perspective? I can think of two ways but I'm not sure which one is bett...
We have constants declared in an interface in our application like this. public interface IConstants { public static final String FEVER="6"; public static final String HEADACHE="8"; } We now want to populate these constants values (6 and 8) from the database (or application servlet context). The database values stored in a lo...
This is a simplified version of a query I have. Say for each customer that has made an order, I want to know what percentage of their total order value was for green items. There can't be multiple items in an order, but it's possible for the order value to be zero so I want to avoid division errors. (And no, I am not able to change the ...
Hi, I use the next code to retrieve data from a table in the database: $check_sql = 'SELECT personID, name, DATE_FORMAT(persons.birthdate, "%d de %M, %Y"), birthplace, countryID FROM persons WHERE personID = ?'; if ($stmt->prepare($check_sql)) { $stmt->bind_param('i', $pid); $stmt->bind_result($personDB, $name, $birthdate, $birthpl...
I found couple of discussion threads on this- but nothing which brought a comparison of all three mechanism under one thread. So here is my question... I need to audit DB changes- insert\updates\deletes to business objects. I can think of three ways to do this 1) DB Triggers 2) Hibernate interceptors 3) Spring AOP (This question i...
I am trying to compare the performance of the different calls (getBytes/getBinary/getBlob) for getting data out of a BLOB column. What I am doing right now is tracking the time to execute the statement via the jdbc driver and iterating through the resultset. //Mark time ResultSet resultSet = stmt.executeQuery(query); resultSet.getByte...
So lets say that you want to learn some stuff about database internals. What's the best source code to look at? the best books to buy? I was talking about this with a buddy the other day and he recommended: Art of Computer Programming, Volume 3: Sorting and Searching What other books would help me learn about all the File IO and memory...
I'm trying to understand E.F.Codd's "A Relational Model of Data for Large Shared Data Banks" paper. I would like some suggestions on books / sites on set theory. ...
I've just upload my ASPNETDB.mdf using "Generate Scripts" into server. The problem is, I don't know how can I connect to it for my Membership.(e.g LogIn Controls) where is the ConnectionString? ...
What is the smallest way to store a UUID that is human readable and widely database compatible? I am thinking a char array of some sort using hex values? ...
Hello I wonder if anyone can advise me here; I have an application which has classes like this: Code: public class Order implements Serializable { private int orderNo; private int customerNo; private date orderDate; public int getOrderNo () { return orderNo; } public int getCustomerNo () ...
I have a base class that declares a private non-static reference to the DataBase Handler instance (DBH). DBH is a class we use to simplify database operations of derived classes. It contains the usual methods, like ExecuteScalar, StartTransaction among others; and it provides additional benefits in the application context, like caching...
How do you track/manage your stored procedures, views, and functions in SQL Server? I'd like to use Subversion, but it looks like I would have to just save & commit the CREATE/ALTER statements. That might work okay for me, but I suspect I'd end up doing a lot of nagging. Is anyone using versioning with their databases? Is there a bette...
Are there any best practices to column ordering when designing a database? Will order effect performance, space, or the ORM layer? I am aware of http://stackoverflow.com/questions/34818/sql-server-does-column-order-matter. I am looking for more general advice. ...
I have a c# dll with a number of static utility classes. they all need database access, and at the moment each class has it's own connection. this is getting to be a hassle, and I'd like a single "provider" of connections, so a class could just do something like ConnProvider.Query(...) where ConnProvider is a static class accessible by a...
I need to dynamically populate an Oracle cursor (Oracle 10g). The SQL statement changes, based off of the input value to pull from different tables, and columns. What I don't want to do is have to maintain a temporary table that I truncate and load everytime the sproc is executed. Here is what I am currently doing, but if there is ano...
Which is more important: The design of the database? Or the design of the application code? There is a lot of information out there about reusable code (from Carl Franklin at dnrtv.com, CSLA.net, et. al.), but I don't see too much information about Database Design and its impact on the life of an application (particularly how bad design...
Hello, What kind of databases do product based accounting packages such as MYOB in Australia and Tally & Wings in India use? They don't seem to use SQL SERVER or Oracle. Their storage file appears to be totally different. Without using any third party database package...I'm amazed at how they manage to rapidly grow by adding features. ...