Hi, There seems to be a big push for key/value based databases, which I believe memcache to be. Is the value usually some sort of collection or xml file that would hold more meaningfull data? If yes, is it generally faster to deserialize data then to do traditinally JOINS and selects on tables that return a row based result set? ...
Is there a module written purely in Python that will allow a script to communicate with a MySQL database? I've already tried MySQLdb without success. It requires too much: GCC, zlib, and openssl. I do not have access to these tools; even if I did, I don't want to waste time getting them to work together. I'm looking for tools that will m...
In the Northwind Starters Kit, Primary keys from database are mapped to Strings in C#. Is this good practice? And if so, why? thx, Lieven Cardoen ps: Sorry for the maybe wrong question... In Northwind Starters Kit some tables have a auto-incremental primary key with datatype int and others have a non auto-incremental primary key wit...
I wrote a program that outputs a Python program that fills my Django application with data. This program however is 23 MB large and my computer won't run it. Is there a solution for this? Another possible solution to fill the database would be using a fixture. The problem is that I don't know the new primary keys yet... or I would have ...
Hello, I need SQL to be running on 2 data centers(DC) active/active. There are tonnes of challanges to be done here and below are my requirements. Data synchronization must be async. (For higher performance) I need to be able to read/write on both DC When Site1 goes down, all the traffic will be routed to Site2 and when Site1 comes ba...
I am working on a web app and I decided (after reading many post on SO) to store the actual images in the file system and to store the metadata in the DB. Should I store a relative path or an absolute path. I can think of some advantages for each of the choices. Absolute: Pros: It is obvious where the file is even to other apps read...
What is the ideal way to check if a database exists on a SQL Server using TSQL? It seems multiple approaches to implement this. ...
This question is from a decomposition of http://stackoverflow.com/questions/678471/what-are-good-programming-practices-to-prevent-malware-in-standalone-applications The question has to do with malware dynamically getting into a program by infecting data files which the program reads/writes. Is it safer to require data be stored in a...
I have a table of "posts" and I want to keep track of the ratings for each post. Normally, I would add a rating field with int values in that same table which references another "rating" table that holds actual rating data. Is there anything wrong with removing that rating field and calling the ratings directly from the rating table base...
I'm starting to get involved in an open source project Gramps which is exploring switching their backend from BSDDB to a relational database. Either SQLite or MySQL we haven't fully decided and may even try to do both in some limited capacity. I'm a professional developer but I'm new to python so I'm not that familiar with the current se...
I have a field where I want to store the number of certain rows from another table. I have been incrementing this value when the rows are created, but feel this is probably not the best way. THen again I dont think that doing "count" on the table in question every time makes sense either. what is best approach? EDIT: Count is filtered ...
As captioned, when accessing database in application, is there any disadvantage to use rowid? ...
Here is a curiousity question. I have an application that must support both flat files and the database as a place to persist data. I was thinking maybe using a .csv or tab-delimited set of files as input ... Is it possible to use NHibernate to write to do both persistance tasks? ...
Using SQL Server 2008 and I'm doing some schema construction in the Management Studio designer. I created a table early in the process called "Animal", but then decided to delete shortly after. I deleted it via the tree view in Management Studio (right-click delete). Now I'm late in the process, I would like to recreate the table "Anim...
Two tables, primary key of one is foreign key of another (Legacy DB) I used bi-directional one to one mapping: @Entity public class First { @Id protected int a; @OneToOne(mappedBy ="first", cascade = CascadeType.PERSIST) @JoinColumn(name = "a") protected Second second; } @Entity public class Second { @Id protecte...
Lets say I have the following 2 tables in a database: [Movies] (Scheme: Automatic) ---------------------------- MovieID Name [Comments] (Scheme: Manual) ---------------------------- CommentID MovieID Text The "Movies" table gets updated by a service every 10 minutes and the "Comments" table gets updated manually by the users of the d...
I'm currently in the process of converting some small personal web sites from WebForms to MVC. With the existing sites, the database schema is solid but I had never really taken the time to build proper data/business models/layers. The aspx pages all talked to the database directly using a variety of Views and Stored Procedures that we...
I need to develop a "naive" implementation of database indexes for use in a distributed environment. I know almost nothing about the subject, and I'm a bit pressured by time. I would love to hear some opinions, examples and algorithms on the subject. I'd like to be able to have a mental representation of what I need to implement. EDIT...
Requirement : JAVA desktop mail client which could connect to existing gmail,y! mail a/c & will allow receive/send mails, support offline view of mails, plus with more features as & when it comes. i am using Java Mail Api's Underlying Mail Storage: I have decided to use HSQLDB with Hibernate. Email content can have attachments , HTML ...
Is there a way to compare 2 DateTime variables in Linq2Sql but to disregard the Time part. The app stores items in the DB and adds a published date. I want to keep the exact time but still be able to pull by the date itself. I want to compare 12/3/89 12:43:34 and 12/3/89 11:22:12 and have it disregard the actual time of day so both of ...