I am developing a Ruby on Rails website and I have an "architectural" question : my application needs some parameters and I'm wondering where to store them. In concrete terms, my application receive some requests which are evaluated and then sent. So, the Request model must have attributes concerning these treatments : a validation stat...
I created two (or more) threads to insert data in a table in database. When inserting, there is a field CreatedDateTime, that of course, stores the datetime of the record creation. For one case, I want the threads to stay synchronized, so that their CreatedDateTime field will have exactly the same value. When testing with multi threadi...
What are your experiences with storing consumption tax information in a database (e.g. sales tax, GST etc.). I am looking for elegant and simple methods that will be suitable for Australia, the US and the UK. I am seeking answers from people who have dealt with the more complex intricacies of consumption tax : i.e. the cases where pro...
According to the user's input I want to select the record from the database. This is my code: <% String jempid=request.getParameter("empid"); out.println(jempid); int intempid=1223; Connection conn=null; String url="jdbc:mysql://localhost/employees"; Class.forName("com.mysql.jdbc.Driver").newInstance(); conn=DriverManager.getConnection...
A colleague of mine is working on a .NET application. He needs to write his save function for his object. Normally he would use a stored procedure in SQL Server to do this, but with 40 columns that is quite a task. Several of our other colleagues have preferred using XSD's for their database interaction. What is going to give the bes...
I need to design a DB for a forum. I am separating the root post from it's sub-posts for various reasons. I need the text the user enters to be optimally search-able, also from performance point of view. My question, should I separate each table (root-posts and sub-posts) into two tables: root-posts_meta (hold data such as id,creatio...
Hi I have mysql database and I want to get the last ID from field in a table . example : - id Value 1 david 2 jone 3 chris I want a function return 3 if this table exist . ...
Our postgres server is about hitting its capacity and we're looking into adding a second database server. Are there any scaling solutions that are particularly good for a postgres setup? ...
I HAVE to be missing something really simple here! I have a database in my development environment called Project. I have a database in my test environment called Project_UAT. I've created an SSIS package that successfully copied my database from Project to Project_UAT. I'm pretty sure this eliminates most permission and configuration ...
What are the most reasonable ways to move table data from SQL Server to Oracle (on *nix) on a regular basis? ...
I'm going to be writing a Windows application using the .NET framework and C#. The application will need to store relational data which will be quieried, joined and processed. Previously I've done this using SQL Server, but that is a total overkill for the application I am now making. What's the simplest, easiest way to store relationa...
Currently, I have a blog that is using VistaDB as back-end database, but later I realize that I want to MS SQL Server instead. I was wondering there is any tools that are available for migration data like this problem? ...
I have a MySql database with a certain feild that contains a date. How can I convert it to a C# DateTime object? And how do I convert a C# DateTime object so I can insert it to the database? ...
I have an iPhone game (Combination), and in the next version I would like to set up a server, where users (via the app) can submit which levels they have completed, and see how other users are doing. At this point I don't intend that users will need usernames and passwords, just a simple submit data, get back data. I know very little ab...
It seems like the goal of a lot of ORM tools and custom data access layers (DAO pattern, etc.) is to abstract the database to the point where you could supposedly swap out the entire database system with minimal work. Following the common DAL patterns is usually a good idea in code, but it seems like it would never be minimal work to sw...
Should the ASPNETDB be left in default app folder created by Visual Studio when deploying on webserver? I have another DB that is in the mssql data folder, should that be placed in same directory as well? Im not clear on whether it matters one way or the other. ...
Hi Guys.I am trying to connect to a Sql Server in my apllication using the following code : SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = "Data Source = (local);Initial Catalag = Inventory; Persist Security Info = false; Integrated Secu...
For this university assignment I have a Prize object which contains either text, Image, Video. I would like to save this information into a Blob field in a database which will be running on a PDA on Apache Derby. How can i add this data to the database? Thanks in advanced. ...
Hi! for a program I am writing I would need a dictionary between Spanish and English words. I googled a while, but I could not find any database freely available. Does anybody know where or how to get such a database (preferably a simple CSV or XML file)? So far my best idea to create such a dictionary is to create a little program tha...
I know this is a similar question to one already asked, but I was hoping for a different answers to a problem. I have a form where you can upload new articles to a database all fine works ace, wonderful, brill. The form uses a drop down menu for the type of article, I have news, gossip, travel, performances and others in my drop down box...