We have a data collection system that collects measurements from environmental sensors that measure velocity of water flowing through a river or channel. Each measurement generates a fixed number of values (e.g. Date, Time, Temperature, Pressure etc.) plus a list of velocity values. Originally the sensors supplied three velocity values s...
Cannot dump stackoverflow XMl file into SQL server 2008. Could you please explain in step-by-step. ...
Hi guys, I've made a very simple REST controller method with Spring 3.0.0.RC1 that uses hibernate to perform a query. The query takes about ten seconds to complete. I've made this with intent so that I can fire up two requests to my controller. Then I fire up the two requests, and query in MySQL (my DB backend) "show full processlist",...
I have two tables, both named as say, Employee in two different schema HR and Production [i.e. dbo.HR.Employee and dbo.Production.Employee are my two database objects]. While dragging these two tables in LINQ to SQL design pane its generating two classes named Employee and Employee1. My ques: Is there any way I can create classes with Da...
Hi! I am first day with SOLR, and of course, i have some problems with it. I need to index a database, which is postgresql database. I defined fields in data-config.xml file, added DataImportHandler to solrconfig.xml, added postgresql jar to solr folder. But, when i am starting SOLR, i have the following error: 2009-10-27 16:08:53.28...
If I plan to use MySQL on a web-development project (example.com) where my web application is a commercial product where I'm selling a service and it just so happens that MySQL, using the InnoDB engine, is the backend data storage for my web application ... do I have to purchase a commercial license to use MySQL/InnoDB? If I do have to ...
Age old question! When you have finished developing and testing your ASP.Net web application, the database you want to deploy is now full of test information and needs to be emptied (and identity fields reseeded to 1) before you deploy. When using a server instance, this isnt difficult (create a SQL script to do the job) but when using ...
I have a project which I am developing with SQLite and SubSonic 3. I want to know that how can I avoid the App.config file altogether. How do I tell my program to use SQLite Data provider. I mean, how can I tell it this: <DbProviderFactories> <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework...
I'm creating and app that will rely on a database, and I have all intention on using a flat file db, is there any serious reasons to stay away from this? I'm using mimesis (http://mimesis.110mb.com) it's simpler than using mySQL, which I have to admit I have little experience with. I'm wondering about the security of the db. but the fil...
How can I configure the embedded Jetty that comes with GWT so that when I click the run button in Eclipse, my server application can access a postgresql database? ...
I'm just wondering how to best handle transactions across multiple service layers. The service layers use an ORM to store and retrieve from the database. Should the transactions be known and handled within the individual service layers? Or should they be handled by another layer? For example: I have two service layers for users and clie...
Hi, a quick question in regards to table design.. Let's say I am designing a loan application database. As it is right now, I will have 2 tables.. Applicant (ApplicantID, FirstName , LastName, SSN, Email... ) and Co-Applicant(CoApplicantID, FirstName, LastName , SSN, Email.., ApplicantID) Should I consider having just one table beca...
Hello, I am beginning work on a relatively large web-based application with the potential for large throughput and storage of a large amount of data. My expertise lies in MS SQL Server but it is cost prohibitive for a startup project. Is there any alternative to SQL Server (standard) that can handle the same throughput, has similar f...
I am creating a rails application that needs to store a large amount of sensitive data. To assure my customers that the data is being protected, I want to encrypt it on a per-user basis. I have done research looking for gems that can accomplish this. So far I've found strongbox and safe. Together, this would seem to provide a solutio...
What should be changed in Joomla's database to put content to the frontpage? I've got a great deal of articles and making it by hand would take a lot of time. So I'm looking for an automatic way. ...
I'm looking to use either Firebird or Postgres in my next development project ... largely because both are available under a BSD-like license. I found a great comparison of the two database at http://www.amsoftwaredesign.com/pg_vs_fb But this comparison is a good 2+ years old and both databases have come a long ways since. Does anyone...
Hashtables seem to be preferable in terms of disk access. What is the real reason that indexes usually implemented with a tree? Sorry if it's infantile, but i did not find the straight answer on SO. ...
How can I insert an image in MySQL and then retrieve it using PHP? I have limited experience in either area, and I could use a little code to get me started in figuring this out. ...
I have a postgresql database. In table, which i need to index, i have about 20 million rows. When i want to index them all in one attempt(smth like "select * from table_name"), i have Java OutOfMemory error, even, if i`ll give to JVM more memory. Is there any option in SOLR to index a table part by part(e.g. execute sql for first 10000...
I want to create an SQL script that creates a database. Right now, I have this: CREATE DATABASE [Documents] ON PRIMARY ( NAME = N'Documents', FILENAME = N'Documents.mdf') LOG ON ( NAME = N'Documents_log', FILENAME = N'Documents_log.ldf') COLLATE SQL_Latin1_General_CP1_CI_AS However, this generates the following error: Msg 5105,...