When I run the EXPLAIN command on my MySQL query: EXPLAIN SELECT colZ FROM table1, table 2 WHERE table1.colA = table2.colA AND table1.colB = table2.colB AND table1.colC = X The EXPLAIN command states that the possible_keys include: colA, colB, colC But the actual key used as colA Question: Does this imply I should make an index o...
This is about a simple yet efficient activity logging framework that I want to integrate with my existing ASP.Net based web-app (I've a LINQ-to-SQL based SQL DB as backend). I'm using something like a service-architecture to perform DB operations - that is invoke relevant LINQ operations. I've a service class for almost every entity (i.e...
Dear guys I get a base 64 string from a XML file which I want to insert into my SQL Server database. Which field type have the field in my database to be? varbinary(MAX)? Do I have to convert the base 64 string to another format before inserting into my database? Best regards ...
The following is the piece of java code by using filters that shows the error page at every time if the username and password is also correct. Please help me, I don't have much knowledge on this concept. String sql="select * from reg where username='"+user+"' and pass='"+pwd+"'"; rs=st.executeQuery(sql); if(rs.next()) { chain.doFilt...
I found a php calendar class http://style-vs-substance.com/calendar-class-php/clendarclassphp-updates-and-new-version-release/#more-37 When I hover a day gives a link, such as http://127.0.0.1/2009/12/24. I want to add an event when I click a date. Now my question is what is the best structure of calendar database. Should I make a di...
I have two tables where foreign key cannot be set so is it necessary to assign foreign key any way? ...
How to use DATEDIFF? How can I make this to work? or should I use DATEDIFF completly differently? SELECT DATEDIFF('Started ','will_end') AS 'Duration' FROM my_table WHERE id = '110'; I try to get answer, how many days are inside of two dates. I would like to get an aswer like: Duration = 7 days; I have this kind of database: Start...
I have in my MySQL database both longitude and latitude coordinates (GPS data). It's currently stored as: column type ------------------------ geolat decimal(10,6) geolng decimal(10,6) Question: Do I really need a data type as large as decimal(10,6) to properly store coordinate data? Since I have a combined index on the...
I have a system that stores vectors and allows a user to find the n most similar vectors to the user's query vector. That is, a user submits a vector (I call it a query vector) and my system spits out "here are the n most similar vectors." I generate the similar vectors using a KD-Tree and everything works well, but I want to do more. I ...
Hi, I'm trying to restrict access to a database on my server to only allow users from a specific Windows group. I have enabled Windows authentication for the server, but it seems as if I can only allow access to specific users, not specific groups... is there any way I can do this? Most of the resources I've found contain SQL Server 2...
I'm planning a web application using Django, and it's based on a big pile of data from RSS feeds. What would be the best database to use to store the content of a lot of posts and metadata, as well as data about how each user relates to each post? I've heard that the consensus is that ZODB is too slow, but it'd be handy to have a databa...
Here is an explanation of how the elements are related. tl;dr: Intensity is strongest at the center of the diagram. The basic emotions (in the arms) combine to form secondary emotions in the outer circle. (i.e., Anticipation + Joy = Optimism) What is the best way to design a database to model this set of relationships? ...
Every SQL Server connection string I ever see looks something like this: Data Source=MyLocalSqlServerInstance;Initial Catalog=My Nifty Database; Integrated Security=SSPI; Do I need the Initial Catalog setting? (Apparently not, since the app I'm working on appears to work without it.) Well, then, what's it for? ...
I kept thinking a lot about the meaning of migrating a Django app the last few days and heard about migrating Django apps with django-south. Maybe it's just the lack of sufficient English skills (as English is not my native language) or this is one of the things you confront in a programmer's life which are so simple, that it takes a gen...
Hello I wrote an app android sdk version 1.5 using it's built in emulator in eclipse. I created a database outside of eclipse populated it with data and push it to the emulator folder data/data/project name/database and could access it fine from the my app, everything was working great. My final step was to test the apk file on an actua...
hi guys, please help me on this one:) Most of the time I am creating static pages like Contact Us, About Us, FAQs etc If I want to store some dynamic items in the page, how will my table look like? Let's say for the FAQ page, I am to store the question and the answer on the database. For the contact page, I will store emails and and s...
phpBB stores forum post texts in a strange way (like: [BLOB - 115 B]), what is it? How it is done? ...
Dear all, I am currently at an utter loss. There isnt a single tutorial i read online that covers raising a ValidationError on encountering a duplicate key value in a CRUD application. Basically, I have a data entry form on which on clicking the OK button will insert a record in the database. That table has enforced a primary key constr...
Hello, According to a couple of different postings here on SO "storing images in the database is definitely not recommended by Apple, the filesystem is actually really good at locating files (images in this case) on the disk, which makes it the best solution for saving images." link text I'm currently retrieving data from a remote db u...
I want to manage SQL Server dynamically, that is through code I wan to scan SQL Server for available databases than I want to create new database, access older database, alter it, and insert data into database depending upon table schema what is better approach what should I use? i heard name of nhibernate, SQL Server Management Object ...