I have a classifieds website. Users may put ads, edit ads, view ads etc. Whenever a user puts an ad, I am adding a document to solr. I don't know however when to commit it. Commit slows things down from what I have read. How should I do it? Autocommit every 12 hours or so? Also, how should I do it with optimize? Please give a detaile...
We have a medium size Java application that needs some refactoring. We are considering migrating towards JRuby on Rails. Mainly because of the productivity that Ruby on Rails offers and for the many existing plugins that will reimplement the web logic. However a large part of the application should stay in Java, we do not want to rewri...
Hello, I need to create entities (specifically contracts) in a database table that are associated with a financial year. These contracts will be applied to projects. Any contract variation will be recorded by creating a new contract record for the same financial year but the original will remain associated with the project as a history....
Hi all, I am building a database as a simple exercise, it could be hosted on any database server, so I am trying to keep things as much standard as possible. Basically what I would like to do is a 'code' table that get referenced by other entities. I explain: xcode id code r role p property code r admin r staff p title .... then I ...
In the past, I used to work with windows-1255. Now my new page is written in UTF-8. When I send a query to DB (MS-Access), I get no results. The query on the URL shows the same like I type in by myself, but in this case (typing) I get results. How can it happen that I see the same URL on my IE and get the results and the other (that come...
I develop an app with both thick-client and thin-client components. We also version our database such that schema changes result in their own version number and change scripts can be applied. Database changes, however, don't always occur in step with thick-client changes. Yes, today's database change might add a column and necessitate a ...
I need some suggestions to implement a business rule - whether to keep it in DB (using TRIGGERs) or in App code. --- Table structure:--- # ORG - Master table for Organizations # USER - Master table for Users (each user belongs to an Org so there's a field OrgId which is FK ro ORG) # SITE - Master table for Sites # ORGSITE - {OrgId, ...
At work we have just started developing in C#.NET using VS2008 and we need to connect to Oracle databases. The problem is that we are still using Oracle 10g servers and Oracle provide four install options: Install the Oracle 10g DAC with tools for VS2005 / VS2003 Install the Oracle 11g DAC with tools for VS2008 Install Oracle 10g DAC ...
I have a basic db schema comprising 2 tables; One is a simple ID -> Text list of terms, and the other has 2 columns, parent and child. The ids in the first table are generated on insert by a db sequence while the second table contains a mapping between keys to store the 'structure' of the hierarchy. My problem is that I may want to some...
I have a JSP/Spring application using Hibernate/JPA connected to a database. I have an external program that check if the web server is up every 5 minutes. The program call a specific URL to check if the web server is still running. The server returns "SUCCESS". Obviously if the server is now, nothing is returned. The request timesout a...
I have a bunch of data in a database and I want to generate some tables in PowerPoint. I had started doing this manually but I thought there might be a way I can simply write some code to take my data from the database and output it onto a PowerPoint slide. Any advice here? ...
Background: I have a cclassifieds website, and users may for example search for cars, and specify a price range, mileage, fueltype, gearbox and a manually inputted query-string if they like to put something specific into the search, ex "bmw m3". Questions: I am about to move this information to Solr for faster lookup, and wonder if I ...
I have a queryset with a few million records. I need to update a Boolean Value, fundamentally toggle it, so that in the database table the values are reset. What's the fastest way to do that? I tried traversing the queryset and updating and saving each record, that obviously takes ages? We need to do this very fast, any suggestions? ...
I can't figure how to make a decent website without using the asp.net builtin data controls like SqlDataSource and DataGrid. Is there a cleaner way to do this? ...
How can I connect to MySQL db and execute queries ? ...
I want to rename my SALES cube to SALES_2009 and put a new cube called SALES. When I rename it, the ID remains as SALES so my new cube now is called SALES, but it's internal ID is SALES_2010 (and my old cube is called SALES_2009, but the internal ID is SALES). Can the ID of a SSAS database be changed? I have tried the properties windo...
I have a special case, for example in table ta in database A, it stores all the products I buy table ta( id, name, price ) in table tb in database B, it contain all the product that people can buy table tb( id, name, price .... ) Can I create a view in database A to list all the products that I haven`t bought? ...
This is a follow-up question to my previous one. Situation: Table 1: +--------------------+--------------------+ | v_id | v_name | +--------------------+--------------------+ | 1 | v_name1 | +--------------------+--------------------+ | etc... Table 2: +--------------------+--------...
ORIGINAL QUESTION (How can I display images from a MySQL database in an Access 2007 form?) I would like to use Access 2007 to interface to a MySQL database and display pictures and other data in a form. I already have an Access 2007 application that I don't want to change much, if I can help it. I'm just not sure what data type will w...
Hi im writing a web crawler in python to extract news articles from news websites like nytimes.com. i want to know what would be a good db to use as a backend for this project? Thanks in advance! ...