I have a classifieds website which uses SOLR to search for whatever ads the user wants to search for... SOLR then returns the ID:s of all the matches found. I then use the ID:s to fetch and display the ads from a MySQL table. currently I have one huge table containing everything in MySQL. Sometimes some of the fields are empty because f...
Possible Duplicate: Surrogate Vs. Natural/Business Keys The title says it all. If given two tables, Level1 [ID, Title, Number] Level2 [ID, FKID???, Title, Number] A user of the system understands that Level2 is related to Level1 with based on Level1's Number, my question to you is, would you make the relationship based on the...
Is there any free database of hashes of malware? I'd like to get a real database of those hashes, so is there any place where this is possible to collect data? I've found http://www.team-cymru.org/Services/MHR/, but they don't offer a real database, only API access.. If not, do you have any idea how to collect it on "my own"? ...
Website: Classifieds website (users may put ads, search ads etc) I plan to use SOLR for searching and then return results as ID nr:s only, and then use those ID nr:s and query mysql, and then lastly display the results with those ID:s. Currently I have around 30 tables in MySQL, one for each category. 1- Do you think I should do it di...
I am writing my first Android database backend and I'm struggling to unit test the creation of my database. Currently the problem I am encountering is obtaining a valid Context object to pass to my implementation of SQLiteOpenHelper. Is there a way to get a Context object in a class extending TestCase? The solution I have thought of i...
Hi, I'm building my first Rail App and are beginning to setup my database. I have a simpel Users table containg name, e-mail (login), password and so on. The site lets the users bet each other (with monopoly money), so I need to add information about the users current winnings and other delicate matters to the database. Question: Sho...
I have a calendar built using PHP, with events on it. I'm using jQuery UI to enable drag and drop to move the events around. The .droppable() function has a callback function attached that updates the database with the new information. But the calendar needs to refresh so that it reads from the new database values. Can you force a pag...
I have found the "pure SQL" answers to this question. Is there a way, in Rails, to reset the id field for a specific table? Why do I want to do this? Because I have tables with constantly moving data - rarely more than 100 rows, but always different. It is up to 25k now, and there's just no point in that. I intend on using a scheduler in...
(using Ruby on Rails and ActiveRecord) In short: Is there some way how a model can use different DB schema for each request? Why I need id: I have a working intranet application working for one company but I decided I would like to offer it to other companies. The Rails way would be to add company_id to each model and alway use this sc...
I am using Visual Web Developer and Microsoft SQL server. I have a tag table "Entry_Tag" which is as follows: entry_id tag_id I want to make the entry_id and tag_id pairing unique. A particular tag can only be applied to an entry once in the table. I made the two columns a primary key. They are also both foreign keys referencing the id...
Hello, I have a DCT that is being used to populate a database using DataDeploy to send the content from the DCR to the database. Everything works fine when I create or update the DCRs, but when I try to delete a DCR, DataDeploy doesn't delete the record in the database. Any thoughts? ...
I'm writing a plug-in for another program in C#.net that acts as a catalog creation and search tool for custom content we've created at my office. An administrator will picks a root catalog folder, and the app will then parses through all the subdirectories looking for specific file types. Then it generates a Catalog by saving the rela...
I was very surprised when downloaded two imageboard php scripts. There is no connection to database, threads and posts are listed as files and folders. Is this way faster than standard mysql database connection or there is another reason? ...
i need to move selected data from 800+ tables in one database to the same 800+ tables in another database in another server. The data i select is based on date fields of every table. So, if i say table 1 date from 01/01/10 to 01/15/10, then only that data i want to be copied into the other server's database table specified. i hope i am n...
Hi, I'm trying to insert a local database cache template to a Visual Studio web application, but the template is not available. If i create a Winodws forms application, the template is available. How can i add this to the web application? I need to create an sdf of my database. thanks ...
Ok so I had first downloaded SQL Server Express 2008 and Wed Developer Express 2008, and I could not integrate the two together. Was getting error messages that were wasking for the correct version of SQL Server 2005, so.... I uninstalled SQL Server Express 2008, and installed SQL Server Express 2005. Now I open the Visual Web Develope...
Hi, Almost all the applications I worked on involve some look-up values. For example, a lot of times a list of languages ( English, French, etc...) need to be displayed on the WebForm for user to choose. The common data structure for such look up values include an integer Id and a string as name. Since these look-up values are used so...
Hi, I have this problem where I need to design a java package which is used for: Getting data from different datasources. For example, Class A will retrieve customer data from a Oracle database, while Class B will retrieve the same information from a webservice datasource (via soap). The results will need to be combined, the rule for ...
This query method works : SELECT xxx FROM xxx-table WHERE YEAR( CURRENT_DATE( ) ) - YEAR( '1988-10-27' ) - ( DATE_FORMAT( CURRENT_DATE( ) , '%m-%y' ) < '12-31' ) Between 20 and 25 But what I need is something like this... SELECT YEAR( CURRENT_DATE( ) ) ...
Hi, I have a query regarding What happens to previous data when app is upgraded to new version . I have a current application having a local database. The user can modify the database. Now If I upgrade the application to next version with some new functionality what will happen? Will it completely replace the database or I can still u...