Hi, I am in process of designing my CMS that I am about to create. I was thinking about the database and how I want to go by approaching it. Do you think its best to create 1 master database for all my clients websites? or Should I have 1 database per site? What is the benefits and negatives on both approaches? I am always thinking abo...
I'm working in Visual Studio C# and want to make reports with Crystal Reports, but this software will be installed in another computer, so my question is how I can send as a parameter the local server name and the path where the file .rpt will be located to the Crystal Report so the application would be generate the report in any compute...
Hello, I was wondering what the "best" way to verify the structure of my database is with SQLite in Qt / C++. I'm using SQLite so there is a file which contains my database, and I want to make sure that, when launching the program, the database is structured the way it should be- i.e., it has X tables each with their own Y columns, app...
Hi everyone, My application needs to retrieve information about any published book based on a provided ISBN, title, or author. This is hardly a unique requirement---sites like Amazon.com, Chegg.com, and even software like Book Collector seem to be able to do this easily. But I have not been able to replicate it. To clarify, I do not ne...
I have 2 tables : The table Data : id, plus many fields. Some of these fields are 'codes' which reference multilanguage values from the next table, for example country_code, continent_code. The table Thesaurus which contains the multilanguage codes, with columns: code, code_type, language, text. Code is unique for one code_type but the...
Hi The title pretty much says it all, but here's some background. We have a database configured in glassfish accessed by a website deployed on glassfish, we also access the database from an external java application, it occurred to me that this could be somewhat inefficient since we open quite a few connections to the database from our...
Hi there. I'm implementing a logging feature on a asp.net mvc2 application, that uses SqlServer2008 as a database and Entity Framework as a data model. I enabled CDC feature of SqlServer and it's logging changes well, but I just noticed that some of the old logging data is erased. Does anyone know what's default period CDC keeps recor...
Hi guys! Does anybody know how to do smart database update in realtime. E.g. I have a site with a great database. Suddenly I've made some code changes and database structure and data changes. Is there any standard plan to do it with deploy script or any deploy soft? In realtime without stopping the site? E.g. switch between two clone...
I have 2 tables in a mysql database : users and pets. In the users table there is a field that contains a semicolon separated list of the pets that a user has (pet_ids = 1;2;3;4;). These ids correspond to unique ids (keys) in the pets table which contain the pet name (1 = rex, 2 = goldie, 3 = squeak, 4 = bubble). I want to present a lis...
Hi, We've currently got the current server set up for a site: Server 1: Admin System & Database Server 2: Public site Server 3: Public Site Server 2 and 3 are managed using the Windows Network Load Balancing system. They are both running copies of the public site code. The sites rely heavily on sessions because they work with user...
Hello, I saw a similar question which asked how to monitor the progress of a backup / restore operation: http://stackoverflow.com/questions/152447/is-there-a-sql-script-that-i-can-use-to-determine-the-progress-of-a-sql-server-ba I would like to know if there's a similar query / way to see how much time the query has left until it will...
Hi, I am building a small cms system in MVC.NET, and I have some editable variables to store. Footer information, website title etc. These are Global variables so they should only be declared once. These should be editable in the cms. Where could I store them ? Isn't it a bit stupid to create a table for them, there they only would occ...
Hi, I'm new with EntityFramework. My application has a pool of context object instances (Each context has 1 connection to the DB). The problem is that when I update an object (and calling SaveChanges), the data is updated in the DB and in the updating context but when I select from other instance, it gets the old data of the selected ...
I basically want to convert a table from mysql to sqlite with the following scheme: create table items ( id integer auto_increment, version integer default 0, primary key (id, version) ); Essentially, I want ID to auto increment whenever I insert anything into the table, with VERSION starting off at 0, but still allow multiple items w...
Hi, I have table with sequence and trigger so it creates new id when inserting it to the DB. How can I get the new object id, before calling SaveChanges()? I need this id for the links between the new object and other objects. I want to do it before calling SaveChanges because I want to have the option to rollback. Can someone solve...
I need to create an ASP.NET site which can display graphs, charts, statistics for a dashboard type application pulling data from a backend data source. I am trying to locate either: (a) open-source modules that I can use / build up on (b) tutorials which teach the above (c) existing modules (preferably low-cost) that work well. I d...
I am trying to post some content to my google buzz account using google buzz api. I tried using their sample code that they have provided ,but it give the below error Array ( [http_code] => 401 [headers] => Array ( [WWW-Authenticate] => AuthSub realm="https://www.google.com/accounts/AuthSubRequest" allowed-...
I would like to build a database of pictures. Each picture may have 1 or more tags, for example: Paris, April 2010, David. How would you store this information ? I thought to have a Files table with 1 row per file, and one of the columns would be Tags IDs separated by commas, for example: 2,4,14,15 In other table called Tags I thought ...
Hello all DevExpress devs! =) I'm trying to tame Express Persistent Objects remotely. Actually, XPO allows two different approaches - accessing the database directly, and through WebService/WCF. For security reasons, we've chosen second option. Now, WCF wraps database access, and clients must authenticate themselves in order to acce...
Hello Good People! i'm getting my hands around the liquibase library and i'ld like to mimic working with existing database. So from command line i manage to generate the changelog and i was wondering whether it's possible to generate insert statements for data insides the tables? thanks for reading this. ...