bakks/virginian - GitHub
february 2012 by mcroydon
GPU database engine.
GPU
performance
database
SQL
february 2012 by mcroydon
Developers Need to Index | SQL Performance Explained
september 2011 by mcroydon
An article/series on SQL performance.
database
development
optimization
index
sql
september 2011 by mcroydon
Basho Riak: Schema Design and the Transition from Relational Databases
december 2010 by mcroydon
A solid collection of introductory to deep dive material for folks used to having it easy and relational.
riak
nosql
sql
data
migration
december 2010 by mcroydon
Membase.org
september 2010 by mcroydon
Another NoSQL k/v store but this one pushes some impressive numbers.
apache
architecture
bigtable
cache
caching
cluster
database
development
db
datastructures
databases
distributed
facebook
key-value
keyvalue
memcache
kvs
scalability
programming
opensource
memcached
nosql
scaling
software
storage
sql
webdesign
webdev
zynga
september 2010 by mcroydon
Another PostgreSQL Diff Tool - Welcome to Another PostgreSQL Diff Tool
june 2010 by mcroydon
Useful for diffing database schemas.
admin
configuration_management
database
databases
db
java
free
evolution
differences
diff
development
dba
management
oss
migration
postgres
postgresql
tools
tool
sql
schema
programming
dbms.postgresql
june 2010 by mcroydon
NoSQL vs. RDBMS: Let the flames begin! – stu.mp
march 2010 by mcroydon
Flamewar aside, it's an interesting discussion.
cost
data
database
databases
decisions
domain
ec2
sql
scaling
rdbms
performance
nosql
mysql
make
experience
simplegeo
march 2010 by mcroydon
Visual Guide to NoSQL Systems - Nathan Hurst's Blog
march 2010 by mcroydon
Nice overview and placing various NoSQL implementations on the CAP subway map.
blogs
database
databases
db
guide
hbase
nosql
visualization
sql
march 2010 by mcroydon
assertTrue( ): NoSQL Required Reading
december 2009 by mcroydon
A good collection of reading materials.
programming
database
reference
development
toread
webdev
scalability
blog
architecture
distributed
databases
scaling
todo
cloud
db
resources
paper
sql
couchdb
reading
to-read
papers
nosql
read
bigtable
scale
links
collection
to_read
readlater
december 2009 by mcroydon
LucidDB Home Page
october 2009 by mcroydon
"LucidDB is the first and only open-source RDBMS purpose-built entirely for data warehousing and business intelligence. It is based on architectural cornerstones such as column-store, bitmap indexing, hash join/aggregation, and page-level multiversioning."
programming
software
development
database
data
business
opensource
java
scalability
storage
distributed
cluster
databases
sql
db
datamining
olap
columndb
bi
datawarehouse
dbms
reporting
rdbms
luciddb
column
warehousing
column-store
data_warehouse
column-oriented
dwh
october 2009 by mcroydon
Graphs in the database: SQL meets social networks – techPortal
october 2009 by mcroydon
Modeling graphs in SQL.
programming
code
database
toread
webdev
howto
tutorial
blog
network
algorithms
performance
article
social
databases
postgresql
graph
mysql
linkedin
datastructures
socialnetworking
webdevelopment
networks
facebook
sql
db
php
graphs
socialnetworks
october 2009 by mcroydon
bobby-tables.com: A guide to preventing SQL injection
october 2009 by mcroydon
How to avoid little bobby tables in several languages. There are more subtle attacks but handling the basics right is the first step.
programming
development
database
webdev
howto
computer
rails
hack
security
coding
hacks
fun
databases
geek
hacking
mysql
tips
sql
db
bugs
c#
injection
tables
sqlinjection
sql-injection
october 2009 by mcroydon
Digg the Blog " Blog Archive " Looking to the future with Cassandra
september 2009 by mcroydon
NOSQL is a hammer, but a shiny one.
programming
development
data
database
toread
blog
storage
scalability
architecture
performance
distributed
scaling
article
databases
mysql
cloud
sql
keystore
nosql
cassandra
acm
keyvalue
key-value
bigtable
production
advice
digg
to-read
deployment
september 2009 by mcroydon
python-sqlparse - Google Code
september 2009 by mcroydon
"sqlparse is a non-validating SQL parser for Python. It provides support for parsing, splitting and formatting SQL statements."
python
programming
django
software
linux
code
tools
database
presentation
opensource
library
databases
sql
module
parsing
parser
parse
pretty
formatting
googlecode
format
sparql
komodo
sqlparse
september 2009 by mcroydon
HadoopDB Project
july 2009 by mcroydon
Interesting approach, we'll see if it has legs.
programming
software
development
database
java
opensource
research
scalability
distributed
performance
scaling
hadoop
cluster
postgresql
databases
mysql
hadoopdb
map-reduce
hive
dbms
rdbms
2009
analytics
postgres
db
sql
mapreduce
yale
vldb
july 2009 by mcroydon
braindump: NOSQL debrief
july 2009 by mcroydon
Slidedump.
software
nosql
kvstore
mongodb
dynomite
video
database
scalability
storage
architecture
distributed
scaling
hadoop
presentation
mysql
databases
db
sql
slides
couchdb
conference
videos
bigtable
hbase
trends
keyvalue
key-value
cassandra
voldemort
hypertable
july 2009 by mcroydon
Engineering @ Facebook's Notes | Facebook
june 2009 by mcroydon
Big big big data warehousing / data mining.
design
data
database
blog
java
map
scalability
storage
distributed
computing
scaling
article
hadoop
sql
mapreduce
db
reading
facebook
analytics
rdbms
arch
comment
hive
datawarehouse
warehouse
data-warehousing
hdfs
dw
june 2009 by mcroydon
MIT Database Systems (6.830) TA Course Notes - marcua's blog
june 2009 by mcroydon
Good looking lightweight TA notes.
programming
reference
data
database
tutorial
toread
blog
education
free
computing
databases
learning
cs
mapreduce
sql
db
notes
academic
mit
course
lectures
lecture
courses
class
rdbms
bigtable
systems
6.830
10
ta
june 2009 by mcroydon
Getting Started With Sqoop | Cloudera
june 2009 by mcroydon
Um, kinda awesome!
scalability
hadoop
rdbms
sql
cloudera
june 2009 by mcroydon
Sequoia
may 2009 by mcroydon
"Sequoia is a transparent middleware solution offering clustering, load balancing and failover services for any database."
database
java
performance
cluster
postgresql
mysql
clustering
sql
tool
db
replication
ha
jdbc
highavailability
may 2009 by mcroydon
Greenplum: the petabyte-scale database for data warehousing and business intelligence.
may 2009 by mcroydon
Petabyte data mining and data warehousing.
programming
software
development
data
database
business
technology
opensource
storage
scalability
performance
cluster
postgresql
startup
open
postgres
sql
mapreduce
datamining
db
analytics
oss
reporting
rdbms
intelligence
bi
businessintelligence
datawarehouse
greenplum
bizgres
may 2009 by mcroydon
touchcode - Google Code
march 2009 by mcroydon
Includes TouchJSON (a JSON library) and TouchXML (a wrapper around libxml2). MIT licensed, baby.
programming
mobile
development
code
apple
mac
library
osx
dev
api
xml
opensource
framework
iphone
source
json
ipod
sql
macosx
cocoa
touch
sdk
repository
sqlite
objc
objectivec
objective-c
touchcode
iphonedev
iphone_dev
license:mit
march 2009 by mcroydon
How FriendFeed uses MySQL to store schema-less data - Bret Taylor's blog
february 2009 by mcroydon
Might as well not be using mysql...
python
programming
design
web
software
development
data
database
howto
blog
scalability
storage
architecture
scaling
performance
databases
mysql
article
json
sql
couchdb
db
index
schema
sharding
friendfeed
rdbms
schemaless
schema-less
blob
february 2009 by mcroydon
High-Performance Click Analysis with MySQL | MySQL Performance Blog
january 2009 by mcroydon
Good thoughts on write-heavy systems. A lot of it applies outside the MySQL ecosystem.
design
web
data
database
blog
statistics
storage
scalability
analysis
scaling
performance
stats
mysql
optimization
hadoop
sql
tracking
ad
article
analytics
datamining
english
reporting
db
sharding
seo
warehouse
click
lesen
realtime
datawarehouse
january 2009 by mcroydon
robhudson's django-debug-toolbar at master — GitHub
january 2009 by mcroydon
A little obtrusive but super duper useful.
python
programming
django
web
development
tools
webdev
dev
work
opensource
http
sql
app
apps
debugging
tool
djangocon
middleware
profiling
contrib
debug
toolbar
header
january 2009 by mcroydon
PostgreSQL Replication, PostgreSQL Support, PostgreSQL Consulting
october 2008 by mcroydon
Mammoth Replicator is now available under an open source license.
design
development
database
sysadmin
scalability
cluster
postgresql
distributed
performance
clustering
chart
databases
postgres
backup
sql
irc
high-availability
db
commercial
replication
distributed-computing
october 2008 by mcroydon
PostgreSQL/Materialized Views - Jonathan Gardner's Tech Wiki
october 2008 by mcroydon
Probably more than I'll ever know about materialized views.
programming
code
howto
database
tutorial
books
wiki
postgresql
databases
postgres
article
sql
dbms
views
materialized
materializedviews
view
october 2008 by mcroydon
MySQL :: Using the New MySQL Query Profiler
october 2008 by mcroydon
Maybe I've been using PostgreSQL too long, but I find EXPLAIN ANALYZE much easier than all of this. I guess this is handy if you're creating a whole bunch of temp tables or helping spot insanely inefficient queries.
programming
database
tools
scalability
management
performance
mysql
databases
optimization
sql
test
debugging
db
profiler
profile
query
debug
october 2008 by mcroydon
Column-oriented DBMS - Wikipedia, the free encyclopedia
april 2008 by mcroydon
I want to read up on this someday.
algorithm
compsci
computer
science
computer-science
data
database
databases
development
fast
interesting
performance
programming
reference
software
sql
storage
toread
wiki
wikipedia
@toread
april 2008 by mcroydon
Symbian adds SQL and Location Based Services
april 2008 by mcroydon
Symbian gets SQLite out of the box. Don't forget though that there's been a database built in to Symbian since before it was Symbian.
symbian
sql
sqlite
data
database
mobile
april 2008 by mcroydon
pgFouine - a PostgreSQL log analyzer
february 2008 by mcroydon
This looks insanely useful. Hadn't seen it before.
analysis
analytics
apache
benchmark
database
databases
debian
development
monitor
optimization
performance
postgres
quality
postgresql
scalability
server
software
sysadmin
sql
system
tools
february 2008 by mcroydon
django-mptt - Google Code
december 2007 by mcroydon
Really quite slick.
algorithms
code
cs
database
django
model
python
sql
tree
december 2007 by mcroydon
Receipts [dive into mark]
december 2007 by mcroydon
Just go read it.
funny
system
tech
sql
paperwork
december 2007 by mcroydon
Public Road Conditions and Roadway Construction/Detours Report
december 2007 by mcroydon
This might win the vulnerable website of the day award.
kansas
sql
injection
attack
december 2007 by mcroydon
err.the_blog.find_by_title('Full of Ambition')
august 2007 by mcroydon
Very slick. Similar to mnesia in Erlang.
ruby
sql
erlang
mnesia
database
august 2007 by mcroydon
Dare Obasanjo aka Carnage4Life - Google Scalability Conference Trip Report: MapReduce, BigTable, and Other Distributed System Abstractions for Handling Large Datasets
june 2007 by mcroydon
Nothing super new here but a good roundup of the tools Google uses.
algorithms
architecture
coding
database
design
development
google
scalability
scaling
software
sql
june 2007 by mcroydon
SQL Injection Cheat Sheet
march 2007 by mcroydon
A good roundup of injections.
sql
database
injection
attack
hack
hacking
intrusion
march 2007 by mcroydon
PostGIS Wiki : Examples Join Tables
february 2007 by mcroydon
Relating geo and non-geo data in Postgresql.
sql
geo
geowanking
geolocation
postgres
postgresql
postgis
february 2007 by mcroydon
Enfranchised Mind » Postgres for the win!
december 2006 by mcroydon
Reason 3,287,337 why Postgres rules.
database
databases
development
partition
postgres
postgresql
sql
tables
december 2006 by mcroydon
PostgreSQL for MySQL users | Linux Box Admin
december 2006 by mcroydon
Postgres for MySQL heads.
database
mysql
postgresql
server
sql
december 2006 by mcroydon
MySQL: Search & Replace (UrbanMainframe.com)
december 2006 by mcroydon
I've been using this to fix my "I have no idea where these xhrefs are coming from" problems with Wordpress.
mysql
sql
wordpress
december 2006 by mcroydon
Inteview with H2 Java database author
november 2006 by mcroydon
HSQLDB was the big embedded java SQL database a few years back, it looks like H2 is more of the same but better and faster.
java
database
sql
november 2006 by mcroydon
VSJ | Articles | Solving Sudoku with SQL
march 2006 by mcroydon
Nice (but ugly) hack!
algorithms
code
database
sql
march 2006 by mcroydon
SQL Injection Attacks by Example
january 2006 by mcroydon
When SQL attacks, next on FOX.
sql
security
development
january 2006 by mcroydon
related tags
6.830 ⊕ @toread ⊕ academic ⊕ acm ⊕ ad ⊕ admin ⊕ advice ⊕ algorithm ⊕ algorithms ⊕ analysis ⊕ analytics ⊕ apache ⊕ api ⊕ app ⊕ apple ⊕ apps ⊕ arch ⊕ architecture ⊕ article ⊕ attack ⊕ backup ⊕ benchmark ⊕ bi ⊕ bigtable ⊕ bizgres ⊕ blob ⊕ blog ⊕ blogs ⊕ books ⊕ bugs ⊕ business ⊕ businessintelligence ⊕ c# ⊕ cache ⊕ caching ⊕ cassandra ⊕ chart ⊕ class ⊕ click ⊕ cloud ⊕ cloudera ⊕ cloudkick ⊕ cluster ⊕ clustering ⊕ cocoa ⊕ code ⊕ coding ⊕ collection ⊕ column ⊕ column-oriented ⊕ column-store ⊕ columndb ⊕ comics ⊕ comment ⊕ commercial ⊕ compsci ⊕ computer ⊕ computer-science ⊕ computers ⊕ computing ⊕ conference ⊕ configuration_management ⊕ contrib ⊕ cost ⊕ couchdb ⊕ course ⊕ courses ⊕ cs ⊕ data ⊕ data-warehousing ⊕ database ⊕ databases ⊕ datamining ⊕ datastructures ⊕ datawarehouse ⊕ data_warehouse ⊕ db ⊕ dba ⊕ dbms ⊕ dbms.postgresql ⊕ dbs ⊕ debian ⊕ debug ⊕ debugging ⊕ decisions ⊕ deployment ⊕ design ⊕ dev ⊕ development ⊕ diff ⊕ differences ⊕ digg ⊕ distributed ⊕ distributed-computing ⊕ django ⊕ djangocon ⊕ domain ⊕ dw ⊕ dwh ⊕ dynomite ⊕ ec2 ⊕ education ⊕ english ⊕ erlang ⊕ evolution ⊕ example ⊕ experience ⊕ facebook ⊕ fast ⊕ field ⊕ find ⊕ format ⊕ formatting ⊕ forms ⊕ framework ⊕ free ⊕ friendfeed ⊕ fun ⊕ funny ⊕ geek ⊕ geo ⊕ geolocation ⊕ geowanking ⊕ google ⊕ googlecode ⊕ GPU ⊕ graph ⊕ graphs ⊕ greenplum ⊕ guide ⊕ ha ⊕ hack ⊕ hacking ⊕ hacks ⊕ hadoop ⊕ hadoopdb ⊕ hbase ⊕ hdfs ⊕ header ⊕ high-availability ⊕ highavailability ⊕ hive ⊕ howto ⊕ http ⊕ hypertable ⊕ import ⊕ index ⊕ indexing ⊕ injection ⊕ intelligence ⊕ interesting ⊕ intrusion ⊕ iphone ⊕ iphonedev ⊕ iphone_dev ⊕ ipod ⊕ irc ⊕ java ⊕ jdbc ⊕ json ⊕ kansas ⊕ key-value ⊕ keystore ⊕ keyvalue ⊕ komodo ⊕ kvs ⊕ kvstore ⊕ learning ⊕ lecture ⊕ lectures ⊕ lesen ⊕ library ⊕ license:mit ⊕ linkedin ⊕ links ⊕ linux ⊕ lucene ⊕ luciddb ⊕ mac ⊕ macintosh ⊕ macosx ⊕ make ⊕ management ⊕ map ⊕ map-reduce ⊕ mapreduce ⊕ materialized ⊕ materializedviews ⊕ memcache ⊕ memcached ⊕ middleware ⊕ migration ⊕ mit ⊕ mnesia ⊕ mobile ⊕ model ⊕ module ⊕ mongodb ⊕ monitor ⊕ mysql ⊕ network ⊕ networks ⊕ nosql ⊕ notes ⊕ objc ⊕ objective-c ⊕ objectivec ⊕ olap ⊕ open ⊕ opensource ⊕ optimization ⊕ oss ⊕ osx ⊕ paper ⊕ papers ⊕ paperwork ⊕ parse ⊕ parser ⊕ parsing ⊕ partition ⊕ performance ⊕ pgsql ⊕ php ⊕ postgis ⊕ postgres ⊕ postgresql ⊕ presentation ⊕ pretty ⊕ production ⊕ profile ⊕ profiler ⊕ profiling ⊕ programming ⊕ python ⊕ quality ⊕ query ⊕ rails ⊕ rdbms ⊕ read ⊕ reading ⊕ readlater ⊕ realtime ⊕ reddit ⊕ reference ⊕ replication ⊕ reporting ⊕ repository ⊕ research ⊕ resources ⊕ riak ⊕ ruby ⊕ scalability ⊕ scale ⊕ scaling ⊕ schema ⊕ schema-less ⊕ schemaless ⊕ science ⊕ sdk ⊕ search ⊕ security ⊕ seo ⊕ server ⊕ sharding ⊕ simplegeo ⊕ slides ⊕ social ⊕ socialnetworking ⊕ socialnetworks ⊕ software ⊕ solr ⊕ source ⊕ sparql ⊕ sql ⊖ sql-injection ⊕ sqlinjection ⊕ sqlite ⊕ sqlparse ⊕ startup ⊕ statistics ⊕ stats ⊕ storage ⊕ symbian ⊕ sysadmin ⊕ system ⊕ systems ⊕ ta ⊕ tables ⊕ tech ⊕ technology ⊕ test ⊕ tips ⊕ to-read ⊕ todo ⊕ tool ⊕ toolbar ⊕ tools ⊕ toread ⊕ touch ⊕ touchcode ⊕ to_read ⊕ tracking ⊕ tree ⊕ trends ⊕ tuning ⊕ tutorial ⊕ twitter ⊕ video ⊕ videos ⊕ view ⊕ views ⊕ visualization ⊕ vldb ⊕ voldemort ⊕ warehouse ⊕ warehousing ⊕ web ⊕ webdesign ⊕ webdev ⊕ webdevelopment ⊕ wiki ⊕ wikipedia ⊕ wordpress ⊕ work ⊕ xml ⊕ yale ⊕ zynga ⊕Copy this bookmark: