I've got a database table with a very large amount of rows. This table represents messages that are logged by a system. Each message has a message type and this is stored it it's own field in the table. I'm writing a website for querying this message log. If I want to search by message type then ideally I would want to have a drop down b...
Howdy, I was wondering if anyone knows of a good script to manage a catalog of products. Just need basic stuff, like being able to browse by category and or tags and search. Without many extras, as I'd like to have it working inside a CMS. softpedia has a few scripts, but I'm also considering creating it from scratch. Ideal would be som...
SQL Server XML Schema Collection is an interesting concept and I find it very useful when designing dynamic data content. However as I work my way through implementing Schema Collections, I find it very difficult to maintain them. Schema Collection DDL allows only CREATE and ALTER/ADD nodes to existing schemes. CREATE XML SCHEMA COLLE...
I am trying to make a simple web app. I have a User table which is just an id, name, password and email. The id is a counter so thats assigned automatically. I have a User/Create action which adds a user to the database. They fill out their name, password and email and click submit. My problem is that the field isn't submitting and what...
Hello .. In my database of 5 million records .. Structure of the table: CREATE TABLE IF NOT EXISTS `music` ( `id` int(50) NOT NULL auto_increment, `artistname` varchar(50) NOT NULL, `songname` varchar(50) NOT NULL, `duration` varchar(6) NOT NULL, `url` varchar(255) NOT NULL, `server` int(5) NOT NULL, PRIMARY KEY (`id`), ...
Hello, When I select from SQL Server, I want to get a date, but omit the millisecond value, and I want it to be as a date type. So if I have a value 1/1/2009 1:23:11.923, I want to omit the millisecond but retain the date type, so that it will be the value 1/1/2009 1:23:11.000 (I know you really can't omit the millisecond value with a ...
Our mysql database sometimes crashes on a show column call for a View. The steps that i believe produce the problem are as follows. A view is being run at the same time that another user is logging into the mysql browser. The the database crashes: The following is what i found in the error file. We are using 5.0.45. Any ideas on steps...
Lately we have been testing QlikView in the office. The first impression is good: it has an attractive interface and performs very fast. We want to use it as a database frontend for our customers. We are also trying to determine whether it can take over parts of our relational database structure. However, we are in doubt whether its data...
I'm trying to display query data into multiple TextInput Fields in Flex. <mx:TextInput id="stagInput" text="{acContacts}" width="170" x="120" y="74"/> This is what I'm trying but all that displays is [object Object] I think I need to define the database field I'm wanting to display, but I'm unsure how to do this as TextInput fields d...
This question is somewhat related to this. I want to have document storage along with some complex metadata. I am not using sharepoint. I have a very simple directory structure that goes 2 levels deep. (One folder and documents underneath). I want to store metadata associated with each file....tags, popularity (# of times accessed), cre...
Hi everyone, Our website uses a PHP front-end and a PostgreSQL database. We don't have back-end at the moment except a phpPgAdmin. The database admin has to type data into phpPgAmin manually, which is error-prone and tedious. We want to use Django to build a back-end. The database has few dozens of tables already there. Is it possible ...
I need some project that I can read it's source code and learn the design structure from it.This project should have a database layer, and business rule layer, anyone has suggestions? Thanks in advance ! ...
Do we have to explicitly manage database resources when using Spring Framework.. liking closing all open connections etc? I have read that Spring relieves developer from such boiler plate coding... This is to answer an error that I am getting in a Spring web app: org.springframework.jdbc.CannotGetJdbcConnectionException: Could ...
In C# how can I empty an existing SQLite database? Is it possible via the Connection String? or by the SQLite manager? I don't want to issue a drop all tables statement. I have this code, the new here represents if does not exists create a new one. try { connStr = @"Data Source=" + databaseFilePath + ";New=True;Version=3;"; c...
Hi all, What would be the performance penalty of using strings as primary keys instead of bigints etc.? String comparison is much more expensive than integer comparison, but on the other hand I can imagine that internally a DBMS will compute hash keys to reduce the penalty. An application that I work on uses strings as primary keys in...
What's a good off-the-shelf tool that can be used to perform replication between mysql and oracle in both directions? We're currently looking at DBMoto which is super, but I was hoping there was something less expensive. The requirements are: Easy to configure and maintain through a GUI. Table-level replication selection, with configu...
I have a database, with several tables. The "main" table, called contacts, stores information about contacts, each having an id, a name etc... I also have like, 20 other tables, each representing a certain function, like staff, media ... Each of these function-tables, references the contact table, with a foreign key. I've recently ad...
How does Voldemort compare to Cassandra? I'm not talking about size of community and only want to hear from people who have actually used both. Especially I'm interested in: How they dynamically scale when adding and removing nodes Query performance How they scale when adding nodes (linear)? Write speed ...
What is the right way to save (php, html, js and mysql) code in database ...
Hi - I have a website and want to display search results dynamically meaning that as the user interacts with controls and selects options, the search results are populated in realtime - i.e. the user doesnt need to click the search button. The data is stored in a MySQL relational data base. Now I know this is likely to lead to a large ...