-
Recent Posts
Tweets
Categories
- Android (3)
- Databases (35)
- Deaf (112)
- DeafRead (63)
- FreeBSD (77)
- Linux (33)
- Networking (5)
- Scripting languages (PHP, Perl, etc) (33)
- Uncategorized (361)
- Video (58)
- Web/Tech (144)
Category Archives: Databases
Redis and php-resque on Ubuntu 12.04
During my free time, I help to administer a machine hosting several websites which generate copious amount of traffic and at times, there can be a significant load on the server. These websites require many tasks running on the back … Continue reading
Other Similar Posts
- Ubuntu: How to select and install (or pin) a package from a repository
- Getting Ruby and Rails working on Ubuntu Intrepid
- XAMPP – For aspiring developers who want to create database-driven webpages using open source software
- H.264 codec for Linphone on Ubuntu
- Fedora 15 (64-bit) desktop with Chrome, Flash, Adobe Air, VLC media player
Fantastic and unorthodox solution to a database scaling problem
FriendFeed is one of my favorite sites to visit. It aggregates and shows what users are doing or saying across the Internet. As you can imagine, the database system required to store and query all these activities would be: 1) … Continue reading
Posted in Databases, Web/Tech
3 Comments
Other Similar Posts
- Getting Ruby and Rails working on Ubuntu Intrepid
- An exposition touching upon the rhapsody of PostgreSQL database
- Ubuntu: How to select and install (or pin) a package from a repository
- optimize large data access: Use DataReader
- XAMPP – For aspiring developers who want to create database-driven webpages using open source software
PostgreSQL: How to have a column with a gap-less sequence with no skips in the incremental values
Posted in Databases
Leave a comment
Other Similar Posts
- A cheat sheet of several useful MySQL statements
- Resetting a PostgreSQL sequence
- MSSQL 2000 data types
- Return a range of row results from a SQL query
- How to Quick Load the Apache Log File into PostgreSQL:
_____
Other Similar Posts
- Typepad users: A free account with Feedburner is next to useless.
- 10 Things You Shouldn’t Do with SQL Server
- An exposition touching upon the rhapsody of PostgreSQL database
- Topics of the network security class I’ll be teaching this fall.
- Microsoft Message Queuing (MSMQ) is a godsend
_____
Other Similar Posts
- getting quick count of rows of tables in PostgreSQL
- PostgreSQL SQL to show tables, views and their descriptions
- How to include a variable in PGplSQL DDL code (e.g. COMMENT on TABLE …)
- How to catch exceptions inside PostgreSQL functions
- Merlin Moncure does it again: How to do recursive sets in PostgreSQL using plpgsql
_____
Other Similar Posts
- retrieving value of autoincrement field that I just inserted in MSSQL 2000
- A kludge to do a month DateDiff() function inside PostgreSQL
- Filtering out data in a table using SQL subqueries with an aggregate like MAX()
- Peek into what SQL queries are being passed to your PostgreSQL database
- getting quick count of rows of tables in PostgreSQL
_____
Other Similar Posts
- Finding out which application a file belongs to (FreeBSD)
- more on PostgreSQL installation on FreeBSD
- Peek into what SQL queries are being passed to your PostgreSQL database
- An exposition touching upon the rhapsody of PostgreSQL database
- View running sessions in PostgreSQL
_____
Other Similar Posts
- retrieving value of autoincrement field that I just inserted in MSSQL 2000
- Date related User Defined Functions for MS SQL Server 2000
- Using plperl to split up a string with delimiters in a PostgreSQL function
- The broswer-forking code for XMLHttpRequest
- geek talk: a problem and the solution with Tree::DAG_Node perl module
Merlin Moncure does it again: How to do recursive sets in PostgreSQL using plpgsql
Posted in Databases
Leave a comment
Other Similar Posts
- How to Quick Load the Apache Log File into PostgreSQL:
- PostgreSQL – Showing Tables/Views containing a fieldname
- Netlix perl script
- retrieving value of autoincrement field that I just inserted in MSSQL 2000
- How to include a variable in PGplSQL DDL code (e.g. COMMENT on TABLE …)
_____
Other Similar Posts
- Peek into what SQL queries are being passed to your PostgreSQL database
- PostgreSQL: adding 1 hour to date/timestamp
- Merlin Moncure does it again: How to do recursive sets in PostgreSQL using plpgsql
- How to Quick Load the Apache Log File into PostgreSQL:
- A cheat sheet of several useful MySQL statements
_____
Other Similar Posts
- How to add custom operators in PostgreSQL
- Google Maps Implementations
- A9.com’s new yellow pages- wow!
- San Diego Tent Beach in support of FSSA!
- Finding out which application a file belongs to (FreeBSD)
Peek into what SQL queries are being passed to your PostgreSQL database
Posted in Databases
Leave a comment
Other Similar Posts
- (new) Make row-wise comparisons work per SQL in PostgreSQL 8.2
- Merlin Moncure does it again: How to do recursive sets in PostgreSQL using plpgsql
- View running sessions in PostgreSQL
- An exposition touching upon the rhapsody of PostgreSQL database
- PostgreSQL: adding 1 hour to date/timestamp
_____
Other Similar Posts
- Merlin Moncure does it again: How to do recursive sets in PostgreSQL using plpgsql
- Resetting a PostgreSQL sequence
- architectural bloopers
- How to catch exceptions inside PostgreSQL functions
- How to include a variable in PGplSQL DDL code (e.g. COMMENT on TABLE …)
_____
Other Similar Posts
- How to Quick Load the Apache Log File into PostgreSQL:
- How to catch exceptions inside PostgreSQL functions
- A cheat sheet of several useful MySQL statements
- How to include a variable in PGplSQL DDL code (e.g. COMMENT on TABLE …)
- The last day of this month SQL statement for PostgreSQL
_____
Other Similar Posts