I'd like to keep my database clean of stale almost-accounts, and I was thinking about making new signups and invitations put their data into the welcome email as an encrypted or hashed url. Once the link in the url is visited, the information is then added into the database as an account. Is there something that currently does this? Any ...
SELECT videos.id, videos.game_id, videos.xbox360, videos.ps3, videos.pc, videos.wii, videos.other, videos.thumbnail, videos.vid_info, videos.sdvid, videos.hdvid, UNIX_TIMESTAMP( videos.date_added ) , game_data.name, AVG( video_ratings.rating ) FROM videos, game_data, video_ratings WHERE videos.game_id = game_data.id AND videos.i...
I have a set of checkboxes that an Admin can tick to give users privleges. In my case, the Admin can click these checkboxes: Image on ImageShack. These checkboxes will allow users to view data for those countries/cities. I am trying to rack my brains to do the folowing: 1) How to best insert this permissions into my database 2) How t...
I am working on the design of a database that will be used to store data that originates from a number of different sources. The instances I am storing are assigned unique IDs by the original sources. Each instance I store should contain information about the source it came from, along with the ID it was associated by this source. As an...
I am working on a database application in C#. I had a requirement to display data on a table and I am now done with that. But my business logic is hardcoded to my code. Now I want to go ahead and use Stored procedures with my code. What are the modifications that I need to do. A simple list of steps would be enough :) SqlConnection myCo...
I am developing my project in Java. I would like to know how I can connect to MSAccess. Any links, or small examples would be greatly appreciated. ...
I'm going to write a multi site content management system in ASP.NET. What will be faster: a database for every site, or one database for all sites? Thanks. EDIT: If a database for every site, which database should I use? XML? ...
With IOC I understand you can substitue implementations out by merely editing a configuration file etc. BUT, what happens when the classes are married to particular database tables and sprocs, you can't just swap out an implementation since the classes/entities are tied to particular tables and stored procedures. Am I right here? ...
I've been reading this question, but it doesn't help me. Considering db administration, I think one db with multiple schemas is easier to maintain than the other option, but in terms of performance, which one is better?, is there any advantage from one over the other? TIA. ...
I have a project table with projectId as primary key: **projectId**, projectName, dateCreated, etc. Then, I have a userAccess table using a composite primary key: **userId**, **projectId** Only the users listed in the userAccess table for each project will be able to view the projects. Now, I am trying to write a MySQL query whic...
When developing software that records input signals (numbers) in real time, how can this data be best stored and compressed? Would an SQL engine be good for this, permitting fast data mining in the future, or are there other data formats that would be suitable or compressed enough for upto 1000 data samples per second? I don't mind buil...
Hi all, I am relatively new to PHP, but experienced Java programmer in complex enterprise environments with SOA architecture and multitier applications. There, we'd normally implement business applications with business logic on the middle tier. I am programming an alternative currency system, which should be easy deployable and custom...
I need to store IP address in the most compact way possible, searching is not a concern. This also needs to be compatible on Windows, Linux, and Mac using any DB (MySQL, SQLite, Postgre, etc). Thanks to the ip2long() and long2ip() functions in PHP I can convert a IP4 address to a small int field rather than a varchar(15) or whatever. Th...
I have 2 tables like this: Stock Table product_id bigint(20) qty float Sales Table product_id bigint(20) qty float Sample Data Stock Table product_id---qty 1---10 2---11 3---20 4---50 1---10 3---10 Sales Table product_id---qty 1---2 2---5 3---20 4---40 1---7 I want the following Output after running the Query product_id---qty ...
Suppose I've the 'dom' table which contains two fields code name Code should be primary key. In case if I enter values('SD', 'domnic') then again if I enter ('SD', 'domnic1') in asp.net I've wrote validation so i can receive alert message. protected void ButtonSave_Click(object sender, EventArgs e) { try { if (Mode ...
How i Create Access Database at runtime in C#? ...
I'm trying to write a small accounting app, mainly for my dad's use. His PC is running Windows 98 (and upgrading is pretty much out of the question due to technical concerns as well as logistics). Java 4 and 5 still seem to work with Windows 98, but I'm totally lost about the DB part. Does anybody know a good, up-to-date database that in...
We have this PHP application which selects a row from the database, works on it (calls an external API which uses a webservice), and then inserts a new register based on the work done. There's an AJAX display which informs the user of how many registers have been processed. The data is mostly text, so it's rather heavy data. The proce...
I have a Message object associated with a User object (user_from and user_to). I persist the Message instances into a database using Hibernate (with JPA annotations) and the user_id is persisted. The User object is also stored to the database, but when fetching messages I would like the User to be fetched from a Map in memory instead of...
So here the scneario. We have a database of read only records that contains about 3 million rows. This database is used by all of our application databases for data lookup. We placed this database on a new server and used a synonym to point to it in the local database. The synonym was pointing to a view on the remote server. This allow...