class Content(models.Model): .....stuff here class Score(models.Model): content = models.OneToOneField(Content, primary_key=True) real_score = models.IntegerField(default=0) This is my database schema. As you can see, each Content has a score. How do I do this: Select all from Content where Content's Score is 1? ...
I have to create a table and store Active Directory SIDs representing an User or a Group. How would you name the category representing both an User and a Group ? Edit 1. Table will contain four columns : ID ( PK ), SID's Name, SID's value and another column for SID's Type ( 0 for User, 1 for Group ). Please suggest the table name...
I have to use a dbms that support transactions. So I thought mysql + innodb or postgresql. Why Mysql+innodb is better ? Why Postgresql is better ? ...
Lets say I do not want to get the VPS or Dedicated Server required to run constant indexing like with Thinking_Sphinx plugin or many of the other full text search plugins for ruby on rails. I have a bunch of listings in the database with a Name field and category field (among other things). It it possible search for a name in a certain...
Hey guys, I'm new to Ruby and I've been playing around with making some webapps with it and I find it totally awesome. I just recently configured Authlogic to perform authentication within my app and next I would like to create a table that stores user profile information such as address, zip, phone, etc. and then later display some of...
I have the following tables items similars items_similars = pivot table items->similars has a many-many relationship the items_similars has the following field item_id similar_id if I am using InnoDB as my engine, do I need to create a relation between items.id and items_similars.id? or between similars.id and items_similars.id?...
When I output my MySQL Dump Regularly, it outputs a 30MB File. When I use gzip, 0KB. Here is my code: $command = "<path to>mysqldump --opt -h $dbhost -u$dbuser -p$dbpass $dbname | gzip> test.sql.gz"; system($command); Result: test.sql.gz 0 KB --------------------------- $command = "<path to>mysqldump --opt -h $dbhost -u$dbuser -p$...
I'm trying to use Hibernate with JPA/EntityManager to do database activities Right now I'm getting this error and I have no idea what it means. Before I had this code and it works fine. public class JdbcProductDao extends Dao implements ProductDao { /** Logger for this class and subclasses */ protected final Log logger = LogFactory.g...
Hello all, Does anyone have any experience with receiving and updating a large volume of data, storing it, sorting it, and visualizing it very quickly? Preferably, I'm looking for a .NET solution, but that may not be practical. Now for the details... I will receive roughly 1000 updates per second, some updates, some new rows of data ...
I'm currently subclassing TDataset for my job. However the lack of documentation on the process is making this more difficult than it should be. I'm currently wondering what InternalInsert and InternalAddRecord should do? Also if anyone can point me to a good guide that isn't Custom Dataset or the Keeping Hold of Your Things series or ...
There is a wizard that can contain over 150 questions or just 10. Each question can be different from the question asked before. For example, it is possible that one question requires you to answer a "Yes / No" answer, but the next one can contain a multiple choice list with four options. There also should be an opportunity to fill in a ...
im developing a forum and users will be able to upload pictures. i wonder how i should organize the folders for this? should they be sorted by threads or users? but how will they then be organized within these folders? and how could i couple some post's pictures to the database entry? eg, if the post got 5 images uploaded, should i ha...
I know SQL but wanted to master it for use in complex SQL and try to create complex SQL statement in one query. Any book to recommend. I found this book: SQL Design Patterns by Vadim Tropashko. What do you folks suggest? ...
We have been trying out SQL server reporting services. We are using SQL 2008 and Visual Studio 2008. I Have a couple of linked reports, along the lines of Report1: Summary of tickets that are still open past the date that they should have closed. Click through on a line to: Report2: Details of a ticket and it’s dependant history data. ...
I have four tables: Disks, Folders, Files and Links. It is four types of entities, and they can not be merged into one type (e.g. into one table) because they have different number and types of attributes. And there are relationships: Disks can contain Folders, Files and Links; Folders can contain Folders, Files and Links too; Files an...
What are you supposed to do in InternalRefresh when you subclassing TDataset in Delphi? ...
Hello there! I'm searching for a tool to dump a database including DDL and content as plain SQL-SCript, so that in can be archived in plain text format. I know e.g. the Oracle dump tools or mysqldump, but is there a tool which can connect to different datasources and get the job done? GUI would be great. Thanks, Chris ...
After creating a proof of concept for an ASP.NET MVC site and making sure the appropriate separation of concerns were in place, I noticed that I was making a lot of expensive redundant database calls for information about the current user. Being historically a desktop and services person, my first thought was to cache the db results in ...
I want to query a column with two enumerations values. If enum==a or enum==b matches for that column in databse then return me. Does anybody know to do this? I cna make for one enum, but how to add another enum into this. System.Collections.ArrayList list = (System.Collections.ArrayList)_mapper.Run(delegate(ISession session, object[] a...
I am trying to create a simple phonebook program that reads data from a file and stores the content into specific nodes in the list. It works fine if I use my addEntry function with static data, such as: addEntry("First", "Last", "555-555-5555"); If I try to read more than 1 entry from the file, each entry just appears to be whatever ...