1) As far as I know, World of Warcraft runs on Oracle RDBMS. Not sure about the implementation details, however, it seems that low priority data (like the location of a character, attribute status etc) gets dumped into database in intervals and high priority data (level, item transfer) occurs real time (hence the noticeable delay … Read more
A year is an integer and even supports integer arithmetic in a meaningful way so text makes no sense. You don’t have a month or day so date is right out the window. The fine manual has this to say about smallint: The smallint type is generally only used if disk space is at a … Read more
Locks are taken during (usually at or near the beginning of) a command’s execution. Locks (except advisory locks) are released only when a transaction commits or rolls back. There is no FOR UNLOCK, nor is there an UNLOCK command to reverse the effects of the table-level LOCK command. This is all explained in the concurrency … Read more
There’s a PgFoundry project that contains several example PostgreSQL databases. Most of these haven’t been updated for a while, but will still work with recent PostgreSQL versions. If you need a bigger database, the MusicBrainz music metadata database has full database dumps available for download.
I found this blog entry which guides you to do these steps: Create a dump of the PostgreSQL database. ssh -C [email protected] pg_dump –data-only –inserts YOUR_DB_NAME > dump.sql Remove/modify the dump. Remove the lines starting with SET Remove the lines starting with SELECT pg_catalog.setval Replace true for ‘t’ Replace false for ‘f’ Add BEGIN; as … Read more
When you create a QSqlDatabase object with addDatabase or when you call removeDatabase, you are merely associating or disassociating a tuple (driver, hostname:port, database name, username/password) to a name (or to the default connection name if you don’t specify a connection name). The SQL driver is instantiated, but the database will only be opened when … Read more
You need to do redis-cli keys ‘*’ to avoid your shell from expanding * into a list of filenames.
Though this post is old but still I see many people not able to get real Auto Complete intellisense feature because as soon as Auto Complete values exceeds 10 then autocomplete doesn’t work i.e you need to explicitly use CTRL+SPACE for displaying intellisense in that case. Please follow the steps so that you will be … Read more
if you are trying to Clone your database on the same server try this: Create a backup of the database you want to copy right-click on Databases and select Restore Database Select the database you want to copy from the From Database drop-down list in the Source for restore section Enter the name of the … Read more
Install Entity Framework Power Tools Beta 4, restart Visual Studio, right-click on the context in your solution view and you’ll see a new ‘Entity Framework’ option in the context menu. Select ‘View Entity Data Model’ to see a beautiful visual database diagram in Visual Studio. Voilà! Entity Framework 6 Power Tools: Link