Does Postgres' Spatial plugin, or any Spatial package for that manner, factor in the altitude when calculating the distance between 2 points? I know the Spatial packages factor in the approximate curvature of the earth but if one location is at the top of a mountain and the other location is close to the sea - it seems like the calculat...
We have a java server connecting to a MySQL 5 database usingHibernate as our persistence layer which is using c3p0 for DB connection pooling. I've tried following the c3p0 and hibernate documentation: Hibernate - HowTo Configure c3p0 connection pool C3P0 Hibernate properties C3P0.properties configuration We're getting an error on ...
Hi, is there an easy way to import a large .sql file of my database on local host without using phpmyadmin. I am using the WAMP server. Thanks for any help. ...
We have a SQL server with many databases in it. We have customers with multiple versions of a similar app and multiple apps for a single customer. Almost all databases are tied to specific websites. How do you stay organized with your database names? Surely there is no single answer, but do you have a database naming strategy that is w...
Hello, The problem is the following, I have a table of friendships in my database, the friendship table has two foreign keys to the users table. I want to set a unique key on the two foreign keys so that I will have no duplicates, but I want more, I want that if user A added user B, then B won't be able to add A, and I want to have on...
I'm implementing generic, persistent .NET collections based on top of the ESENT database engine (using the ManagedEsent interop layer). So far I have been focusing on classes that exactly mimic their System.Collections.Generic counterparts, except that they take a path in the constructor indicating where the database should go. Code like...
Scott W. Ambler has put up a good list of basic database smells. It would be good to see how these can be corrected, what database refactorings can be applied as a remedy and if any smells are missing from the list. For "ground rules" when replying, take a look at question on programming smells if you please. ...
Hi, I put a String value (Edittext input from user in my Search-Activity) in Bundle. Then I get the Bundle (Result-Activity) to check if the user left the Edittext with no value. But It's not work, my If statement have something wrong, it seems like nothing was checked. I debug and saw the code run "If" and then "Else". Can someone help ...
my team is starting a new project on asp.net mvc, and we are wondering what technology for data access to use, how do you think which one is the best, who has the best performance ? which one is easier to use and to maintain ? ...
Does anyone know of a good link that has a listing of the Oracle specific datatypes for a beginner? Thanks! ...
Hello: I've this cursor declaration: DECLARE CursorArticulo CURSOR FOR SELECT HstAt.IdArticulo, SUM(HstAt.Cantidad) As SumaCantidad, HstAt.Precio FROM HstArticulosTickets hstAT INNER JOIN HstTickets HstT ON hstAT.IdTicket=hstT.IdTicket WHERE hstT.NumUsuarioEmisor=@UsuarioAct ...
Using the "Northwind" sample: I would like to create an insert trigger on the OrderDetails table so that every time an OrderDetail is inserted, it gets the current value of the UnitCost as defined in the Products table. It should be something like this, but I have trouble to get it right. Can you help ? CREATE TRIGGER Trigger1 ON Ord...
How can I copy records from two Database, "db1.db" and "db2.db" with different column structure? ...
When taking a database from a relatively un-normalized form and normalizing it, what, if any, changes in resource utilization might one expect? For example, normalization often means more tables get created from fewer which means the database now has a higher number of tables, but many of them are quite small, allowing the often used on...
What is your naming convention for DATETIME columns (in my case, using MS SQL Server) For a column that stores when the row was created CreatedDatetime makes sense, or LastModifiedDatetime. But for a simple table, let's say one called Event, would you create columns called: EventID, // Primary key EventDatetime, ...
Hi, I'm trying to integrate a legacy database in Django. I'm running into problems with some weird tables that result from horribly bad database design, but I'm not free to change it. The problem is that there are tables that dont have a primarykey ID, but a product ID and, here comes the problem, a lot of them are multiple in case of...
We have been storing our staging database on the production database server with the mindset that it makes sense to be as identical to production as possible. Lately, some comments have made me question that idea. Since there is some remote chance that I will do something to production by mistake it may make sense to not put both on the...
I am writing an application that helps book exchange between users. I am using PHP and MySQL, and I am pretty new to them both. I have 5 tables, 3 data tables and 2 service tables: user: with user attributes (user_id, name, birth... etc). book: with book attributes (book_id, name, author, publisher... etc). copy: represents actual co...
I am working on a php program that requires javascript on every form control. Once the onblur event takes place the value will automatically be sent to the server to update the database. I have possibly 50 form controls spread over 5 tabs so I don't want to hardcode the information on the php file. I could co-opt an idea from HTML5 and...
I am bit new to C#. I am working on a Database application and I need to execute a query say a SELECT and load it in to some sort of table view. Then I want to double click on a result and get it loaded to my original data entry form. Can someone tell me the way that I should follow? Dont waste your time to add coding etc. Simply the ste...