It appears there are many ways to approach date and time massaging in php. I usually am only every dealing with local time. Today, I need to work in UTC. I am querying against an API, the data they give me about an arbitrary record is: created: Thu, 18 Jun 2009 21:44:49 +0000 * Documented as 'UTC record creation time' utc_offset: -28...
What I have is basically a problem which is easily solved with multiple tables, but I have only a single table to do it. Consider the following database table UserID UserName EmailAddress Source 3K3S9 Ben [email protected] user SF13F Harry [email protected] 3rd_party SF13F Harry [email protected] user 76D...
Hi folks, I'm trying to write a service in CBuilder 6 (target XP Pro). Part of this service's job is to monitor and update a table on a database. We use direct ODBC to connect to the database, but the problem is happening with ADO as well, so we'll use that for simplicities sake. You can see my code below. This is called from a func...
Hi, I'm currently designing a small application in .Net and in the past I've been using MSAccess as standalone database that I can ship with the program. But I was wondering if in this day and age there wasn't alternative solutions, as easy to integrate in a .Net app., as transparent for the user and maybe better performance with large...
I'm trying to study and I can't find a good explanation of this. And my professor's example is really bad. thank you! ...
I am looking at the activity monitor in MS SQL Management Studio 2005, and I see an entry from a login that I created, and it's using the tempdb, and the last command is always "SELECT INTO". And everytime I hit "Refresh" in activity monitor, that entry's "CPU" column goes up by like 60. The "program" of that activity is "MS SQL Manageme...
Hi In our product we have a generic search engine, and trying to optimze the search performance. A lot of the tables used in the queries allow null values. Should we redesign our table to disallow null values for optimization or not? Our product runs on both Oracle and MS SQL Server. ...
I want to isolate database code from GUI design. For a reasonable time I've been reading/searching/skimming on topics like mgm/mvp/mvc/persistence/objects etc. I really have difficulty in designing a reusable object hierarchy/framework. Delphi is a great tool for RAD but when you want to work things out in a different way the documentat...
In my brand new data warehouse that is built (of course) from the OLTP database, I have dropped all the IDENTITY columns and changed them to INT columns. What are the best practices regarding the following especially since the warehouse is denormalized: Primary Key -> this may now be a composite key because several tables have come t...
Whenever I have some records/objects that I want to be in a certain order, I usually create a field called Ordinal. I often wonder if it would be better to use an integer or a decimal value for the ordinal field. This is a consideration when moving an object to a different position in the order: If you use consecutive integers, you h...
Hey guys, my first question here. I am making a site in RoR and I am inside a multi DB environement. By that, I mean that some of my models are linked to MSSQL tables, and some others are linked to MYSQL tables. It works well for the most part, but when I use the 'include' option in a find method, I get a very weird mix of SQL. Let me ...
From my iPhone app I insert some data in my sqlite database that include a date using the CURRENT_TIMESTAMP default value. Everything works great except for the fact that the time is 1 hour behind the time it should be. And that happens both on the device and the Simulator. Any sqlite settings (like current time) i can access somewhere? ...
We have a grid control that allows a user to filter text in different fields. A number of these fields might be timestamps, like created_at and updated_at. Now, a user can do many different types of filters, including >, <, >=, <=, etc. So, a query that comes across from the control might look like: "created_at > 2009", or "created_at ...
I have an iPhone application that emails my GPS coordinates to an email account. I have some code (here) that I'm using to search that account for emails that contain the GPS coordinates. I wanted a Windows Forms application that would allow me to store the date, time, latitude, longitude and res information of the emails into some sor...
I'm trying to make a class that takes some unspecified data from a database query (passed to my class as an array) and turns it into a PHP object with properties that are created dynamically from the data passed to it. Like so: class myLibrary_Item extends myLibrary { private function __construct($vars) ...
I am studying about cube and i am wonder, is there any databases out there that i can use to study cube? thanks :) ...
I have a Windows mobile project an have added a small sqlite database to it. I have set the "Copy to Output Directory" on the db file to "Copy Always". But how do I get the database to be deployed with the project? ...
I'm working on a project for a school where a particular module deals with attendance system. I'm using LAMP(PHP 5.2+ MYSQL 5+) stack for development. Now the school strength is around 1500 and total number of working days per year is around 250. Plus, I've to keep records for 5 years before it can be erased. The table structure is st...
I tried to look for benchmark on the performances of various filesystems with MySQL InnoDB but couldn't find any. My database workload is the typical web-based OLTP, about 90% read, 10% write. Random IO. Among popular filesystems such as ext3, ext4, xfs, jfs, Reiserfs, Reiser4, etc. which one do you think is the best for MySQL? ...
Hi, Is there an open source object oriented database for C++ available? I had looked at Object oriented Relationship Mapping (ORM) libraries like those posted here: http://stackoverflow.com/questions/74141/good-orm-for-c-solutions and these were intereting as well: http://stackoverflow.com/questions/600684/object-oriented-like-struct...