I've been looking into using DBfDotNet to store some sensor data. For anybody who doesn't know what im talking about, it is a database engine written in c#, check it out on codeplex or this very good codeproject article. The database that it is compared to for timings in the codeproject article is sqlite. From the testing I've done, it ...
I've always wondered how and why they do this...an example: http://youtube.com/watch?v=DnAMjq0haic How are these IDs generated such that there are no duplicates, and what advantage does this have over having a simple auto incrementing numeric ID? How do one keep it short but still keep it's uniqueness? The string uniqid creates are pre...
The requirements for the project I'm working seem to point to using both a relational database (e.g. postgre, MySQL) in combination with a key-value store (e.g. HBase, Cassandra). Our data almost breaks nicely into one of the two data models with the exception of a small amount of interdependence. This is not an attempt to cram a relati...
Hi, reading about NoSQL (http://nosql.eventbrite.com/), a movement aimed at encouraging the dropping of traditional relational databases in favor of custom, application-suited storage systems. Intrigued by the idea of trying to write a small personal storage system (for the .net framework) as a learning pet project, what are you suggest...
I have a csv file, which is generated weekly, and loaded into a mysql database. I need to make a report, which will include various statistics on the records imported. The first such statistic is how many records were imported. I use PHP to interface with the database, and will be using php to generate a page showing such statistics. ...
I am getting started doing ASP.NET on my Mac using Mono, and I'm wondering which databases people have used in this setup. I'd be looking for something that is easy to set up, as this is just for fun and for continued learning of ASP.NET. ...
If I want to perform joins on 3 or more tables, what is the best syntax? This is my attempt: Select * from table1 inner join table2 using id1, table2 inner join table3 using id2, table3 inner join table4 using id4 where table2.column1="something" and table3.column4="something_else"; does that look right? The things I'm not sure ...
Hi All, I have taken the backup of mysql database but when I am trying to restore it my stored procedures are not getting restored. Is there any way like for backup we use --routines in mysqldump command. Can we do any such thing in mysql. If I am using mysqldump then it is just dumping mysql tables but if I am using mysql command to ...
Situation: I am creating a database user interface for a client's website. I know I could simply use phpMyAdmin, but it is too complex for my client. Instead, I though I could give some of the PEAR Packages a try. After doing some research and following tutorials I decided to go with the Structures_DataGrid package. I am currently follo...
We have been having some debate this week at my company as to how we should write our SQL scripts. Background: Our database is Oracle 10g (upgrading to 11 soon). Our DBA team uses SQLPlus in order to deploy our scripts to production. Now, we had a deploy recently that failed because it had used both a semicolon and a forward slash (...
I'm sure this is straight-forward, but how do I write a query in mysql that joins two tables and then returns only those records from the first table that don't match. I want it to be something like: Select tid from table1 inner join table2 on table2.tid = table1.tid where table1.tid != table2.tid; but this doesn't seem to make alot ...
Currently I have an Asp.net website. Basically it was a prototype that showed to my school who are interested in my product. I decided to use this as my industry project that I must complete to graduate. That way if my school decides not to go with it I still can host it myself and target individuals and I complete my requirement for m...
I am developing a video website (PHP - MYSQL), just like youtube, in which I want to provide the functionality of Next video and Previous video. Let's say I am currently on videoId: 234 so Next and Previous video links will point to videoId: 233 and 235 respecively. My table structure is as follows: videoId videoName videoURL ...
I been wondering about this for a while. It seems like there are so many ways now I don't know when to use what? Or if there is even a point to learn them. Like I don't know if they basically do all the same things and just basically stick with one till you master it then maybe look at other ones. So when I was taking an ASP.NET course ...
Is it possible to print ONLY the spreadsheets names (the names at the bottom on the tabs)? I have a workbook with quite a lot of spreasheets (over 500, er, it's a catalogue of music... CDs, what's on them, composors, conductors, movements, times etc.) and would like to do a print out of just the names of, not all and every part of the wo...
Say I have a website and a database of that website hosted locally on my computer (for development) and another database hosted (for production)...ie first I do the changes on the dev db and then I do the changes to the prod DB. What is the best way to transfer the changes that I did on the local database to the hosted database? If it...
Hi , I need to update my data that have html tag inside so wrote this on liquibase <sql> update table_something set table_content = " something <br/> in the next line " </sql> it apparently doesn't work on liquibase ( i got loooong errors .. and meaningless). I tried to remove <br/> and it works. my question is, is it possible to in...
What algorithms are known to perform the task of updating a database by inserting, updating, and deleting rows in the presence of database constraints? More specifically, say that before images of rows to be deleted, after images of rows to be inserted, and both images of rows to be updated are in memory. The rows might be for several t...
So I've asked a couple of questions about performing joins and have had great answers, but there's still something I'm completely stumped by. I have 3 tables. Let us call them table-b, table-d and table-e. Table-b and table-d share a column called p-id. Table-e and table-b share a column called ev-id. Table-e also has a column called da...
So, I am using Google Contacts API to let users import their contacts from GMail. I want the users to be able to select the contacts they want to import in my app, So currently I - GET a XML feed of all the contacts a user has. Parse it, and for each contact create a record in the imported_contacts table. Display the list to the user,...