Hello, How do people make reusable databases that can be used for many products? For example,if we have a database designed for a school...Can it be easily modified to be given to a college? What is the way to create a database that can be used as a product to give solution to many customers with coding just once? Thanks ...
When I go to the 'Add New Item' window in Visual Studio 2005 and try to add a SQL Database it hangs for a bit and then give the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct...
So, here's the deal. I am attempting to write a quick python script that reads the basic id3 tags from an mp3 (artist, album, songname, genre, etc). The python script will use most likely the mutagen library (unless you know of a better one). I'm not sure how to recursively scan through a directory to get each mp3's tags, and then fil...
It looks like Django's looking in the django/db/backends folder but when i install various adapters they install to /django itself - can I point to that? Copying them to the backends doesn't seem to work because it always says blablalb.base is missing... ...
Should I use for a web application Postgres or Oracle XE and why? They are both available for free and for use commercially. Why should I use one database over the other? ...
In a web application architecture with 1 app server (IIS) and 1 database server (MSSQL), if you had to pick one server to virtualize in a VM, which would it be: web or db? Generally speaking of course. ...
Hello, does MySQL allows to create database which has dot (".") in its name? I'm using MySQl 5.1.22. Thanks ...
I have a site that gets just about 100 people everyday but I got this error message when log in as a user: Warning: mysqli::mysqli() [mysqli.mysqli]: (42000/1203): User mexautos_Juan already has more than 'max_user_connections' active connections in /home/mexautos/public_html/kiubbo/data/model.php on line 26 Warning: mysqli::query() [m...
This is related to the Nested Database transactions in C#. The objects in collection I want to take in transaction implement their own transactions using SqlConnection.BeginTransaction method. After reading this post I am not sure if I can mix those too or not. I am using SQL Server 2005 and each object uses connection details from sta...
Duplicate: http://stackoverflow.com/questions/163434/are-nulls-in-a-relational-database-okay I dodged a heated debate concerning nulls in the database today. My opinion is that null is an excellent indicator of unspecified values. Every one else in the team, that has an opinion, thinks zero and empty strings are the way to go. Ar...
As I understand it, the Sinatra framework, unlike Rails, does not provide an ORM. In that case, how do you talk to a DB in a Sinatra app? Or is Sinatra only for apps that don't use a DB? ...
I'm working on a PostgreSQL 8.1 SQL script which needs to delete a large number of rows from a table. Let's say the table I need to delete from is Employees (~260K rows). It has primary key named id. The rows I need to delete from this table are stored in a separate temporary table called EmployeesToDelete (~10K records) with a foreig...
I have used Ruby on Rails with ActiveRecord, so I am quite used to switching to Production/Development database. I am wondering, how do people implement Development and Production Database difference in ASP.NET MVC (preferably with ado.net entity). I tried to have it by creating 2 entity datasets with the same name in a different nam...
I've seen this, so I know how to create a pivot table with a dynamically generated set of fields. My problem now is that I'd like to get the results into a temporary table. I know that in order to get the result set into a temp table from an EXEC statement you need to predefine the temp table. In the case of a dynamically generated piv...
I have the following query in MSSQL SELECT TOP 50 CustomerID FROM Ratings WHERE CustomerID != 915 AND MovieID IN (SELECT DISTINCT MovieID FROM Ratings WHERE CustomerID = 915) GROUP BY CustomerID ORDER BY count(*) DESC It is super fast. When I try to use it in a subquery like this. SELECT * FROM Ratings WHERE MovieID = 1 AND CustomerI...
Currently, we manage database (SQL Server) changes with a series of numbered scripts. One folder holds scripts that can only be run once (table alters, data initialization, etc). Another holds all scripts that can be run multiple times without fear of them destroying anything (stored procedures, functions, etc). Typically, when we need ...
Hey Everyone, I am trying to connect a console application to a access database. This is the query that i have am using: "SELECT [Type], [Name], [Phone Number], [Start Time], [End Time], [IM Session File], [Notes] FROM [Call History] WHERE [Start Time] >= ?" The problem is that for some reason when i take that data from the access da...
I'm looking for a database that supports the following functionality: 1) Records in the database are like Python dictionaries or Perl hashes. For example, a "purchase" record might look like this: <purchase 5436> = { product: "BMX Bike", price: 99.50, city: "Springfield" } 2) The records are stored in arrays of variable length. The d...
Is there a way to do an accent/diacritic insensitive search in sqlite? Googling, I've found this, but I sincerely don't know how to create my "collation function" in C#. I'm trying create the pt-br collation for Sqlite... ...
I've been freelancing for 5 weeks at a Rails shop where I just learned today that the "Technical Lead" of a team of about a half dozen engineers, never applies indexes to the databases backing the websites being developed. I have a week left on my contract and have no idea if they intend on offering an extension. I feel like I owe it t...