mcroydon + databases   84

Cassandra By Example | Rackspace Cloud Computing & Hosting
Cassandra is different enough that it's hard to make it accessible. This writeup does a pretty good job.
articles  cassandra  rackspace  python  database  relational  tutorial  databases  db  twitter  web  example  examples  webdev  webdevelopment  hackernews  howto  nosql  programming 
may 2010 by mcroydon
Cassandra Internals – Writing
A little on Cassandra's internals as it pertains to writes.
cassandra  databases  db  development  key-value  nosql  performance 
march 2010 by mcroydon
Visual Guide to NoSQL Systems - Nathan Hurst's Blog
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
cloudkick | blog: 4 Months with Cassandra, a love story
A very interesting look at Cassandra with an eye toward gotchas. Cloudkick are doing some interesting stuff with aggregation over time periods.
admin  via:jacobian  administration  architecture  article  cassandra  database  databases  opensource  nosql  mysql  monitoring  django  distributed  db  datawarehouse  python  scalability  scaling  storage  toread  webdev  programming  cloudkick  neat 
march 2010 by mcroydon
LucidDB Home Page
"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
Why I like Redis
Redis is indeed awesome (and a little different) due to its support for rich primitive types.
python  programming  data  storage  database  dev  distributed  article  databases  cache  db  memcached  caching  articles  convert  cli  nosql  experiments  redis  schemaless  repl 
october 2009 by mcroydon
bobby-tables.com: A guide to preventing SQL injection
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
Riak - A Decentralized Database
"Riak combines a decentralized key-value store, a flexible map/reduce engine, and a friendly HTTP/JSON query interface to provide a database ideally suited for Web applications." Erlang under the hood.
programming  web  development  key-value  database  webdev  opensource  erlang  storage  scalability  distributed  rest  databases  http  mapreduce  json  db  couchdb  store  kvstore  datastore  keyvalue  nosql  document  cloudcomputing  riak  decentralized  basho  documentoriented  key-value-store 
october 2009 by mcroydon
python-sqlparse - Google Code
"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
PostgreSQL Tips and Tricks
#7 is probably the least obvious and sometimes the biggest help in Django apps and #9 probably the most useful in diagnosing problems. All in all it's a fantastic set of things to remember.
postgresql  databases  list  tips  postgres 
august 2009 by mcroydon
4store - Scalable RDF storage
"At times holding and running queries over databases of 15GT, supporting a Web application used by thousands of people."
programming  web  software  open-source  development  data  database  opensource  scalability  storage  databases  gpl  rdf  store  db  c  semantic  semanticweb  repository  ontology  semweb  semantic-web  triplestore  sparql  garlik  4store  triple-store  rdfstore  triple  websemantique 
august 2009 by mcroydon
The Pathologies of Big Data - ACM Queue
"Scale up your datasets enough and all your apps will come undone."
storage  algorithm  postgresql  databases  compsci  scale  big  data  acm 
july 2009 by mcroydon
Neo4j - a Graph Database that Kicks Buttox | High Scalability
The most common complaint about existing graph databases is performance. Hopefully a stable of good, performant graph databases will change that.
data  database  toread  visualization  java  opensource  network  scalability  cool  architecture  performance  graph  hadoop  databases  db  graphs  2009  arch  socialnetworking  socialmedia  dataviz  neo4j  graph_database  graph-database  relationship 
june 2009 by mcroydon
redis - Google Code
"Redis is a key-value database. It is similar to memcached but the dataset is not volatile, and keys can be strings, exactly like in memcached, but also lists and sets with atomic operations to push/pop elements."
programming  data  google  code  database  opensource  hacking  storage  scalability  performance  databases  cache  memcached  caching  c  memcache  db  memory  key  key-value  persistence  redis  value  kvs 
february 2009 by mcroydon
DataImportHandler - Solr Wiki
I bet this is super fast, but it's a fun intersection of XML and SQL that makes me a little nauseous.
programming  data  java  search  database  databases  mysql  lucene  sql  solr  indexing  find  db  query  import  rdbms 
february 2009 by mcroydon
Washington Post Update - Push cx
Database Journalism at the Washington Post, 2007-present.
web  django  data  journalism  visualization  mashup  databases  webapps  washingtonpost 
january 2009 by mcroydon
MySQL :: Using the New MySQL Query Profiler
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
GenBank Overview
"GenBank® is the NIH genetic sequence database, an annotated collection of all publicly available DNA sequences..."
biology  chemistry  data  database  databases  dna  medicine  mining  reference  science  statistics 
march 2008 by mcroydon
APP.COM DataUniverse | Asbury Park Press Online
An Excellent collection of data resources from another place I spent a fair amount of time as a kid.
data  database  databases  journalism  news  public  research 
august 2007 by mcroydon
Welcome | PostgreSQL for Mac | Andy Satori
This looks pretty good so far, we'll see if Jacob can build against it...
apple  computers  database  databases  development  mac  macintosh  postgres  osx  postgresql  software  sql  tools 
july 2007 by mcroydon
« earlier      

related tags

2pc  2read  4store  6.830  @toread  academic  access  acid  acm  admin  administration  advice  algorithm  algorithms  allegro  allegrograph  alternative  amazon  analysis  analytics  apache  api  app  apple  arch  architecture  archive  archives  article  articles  asp  availability  awesome  aws  backup  basho  benchmark  benchmarks  bi  big  bigdata  bigtable  biology  blob  blog  blogs  books  bugs  business  c  c#  cache  caching  campaign  campaignfinance  cap  cart  case  cassandra  census  chart  charts  checkout  chemistry  class  cli  cloud  cloudcomputing  cloudkick  cluster  clustering  code  coding  collection  column  column-oriented  column-store  columndb  comics  commercial  comparison  components  compsci  computer  computer-science  computers  computerscience  computing  concurrency  conference  configuration_management  consistency  consistent  convert  cool  cost  couchdb  course  courses  cs  data  data-visualization  database  database-journalism  databases  datacenter  datamining  datasets  datastore  datastructures  datavisualization  dataviz  datawarehouse  data_warehouse  db  dba  dbms  dbms.postgresql  debian  debug  debugging  decentralized  decisions  demographics  deployment  design  dev  development  dht  diagram  dictionary  diff  differences  digg  dist  distributed  distributed-computing  django  dna  document  documentation  documentoriented  domain  dot  download  dwh  dynamo  dynomite  ebs  ec2  ecommerce  economy  education  election  elections  engineering  engineyard  erlang  erp  evolution  example  examples  excel  experience  experiments  facebook  farmville  fast  federal  federation  ferrett  filesystem  finance  find  flash  flickr  flockdb  form  format  formatting  forms  framework  frameworks  free  freebase  friendfeed  fun  funding  future  gamedev  games  garlik  geek  genealogy  global  good  google  googlecode  gov  government  gpl  graph  graph-database  graphd  graphdb  graphics  graphing  graphs  graphviz  graph_database  grid  guide  hack  hackernews  hacking  hacks  hadoop  hadoopdb  hash  hashing  haystack  hbase  high-availability  hive  howto  http  hypertable  ideas  image  images  implementation  import  important  index  indexing  info  infrastructure  injection  innovation  inspiration  interesting  interface  internet  irb  irc  jabber  java  journalism  json  jta  key  key-value  key-value-store  keystore  keyvalue  komodo  kvs  kvstore  large  learning  lecture  lectures  library  libs  lightcloud  linkeddata  linkedin  links  linux  list  load  local  lua  lucene  luciddb  mac  macintosh  make  management  map-reduce  mapreduce  market  marketing  mashup  mashups  materialized  materializedviews  math  mathematics  mechanisms  media  medicine  memcache  memcached  memory  mercurial  metadata  metaweb  microformats  migration  mining  mit  module  money  mongo  mongodb  mongoengine  monitor  monitoring  munin  mysql  neat  neo4j  network  networking  networks  news  newspapers  nfs  nodebox  nosql  notes  nyt  nytimes  olap  online  ontology  open  open-source  opensource  ops  optimization  orm  oss  osx  owl  p2p  paper  papers  parse  parser  parsing  partition  paxos  performance  persistence  photo  photos  php  pictures  pig  plurk  politics  population  postgres  postgresql  presentation  pretty  process  processing  production  profile  profiler  programming  public  puppet  python  quality  query  rackspace  rails  rdbms  rdf  rdfstore  read  reading  readlater  recommendations  redis  reference  relational  relationship  repl  replication  reporting  repository  research  resource  resources  rest  review  riak  ruby  s3  samples  scalability  scalable  scalaris  scale  scaling  schema  schema-less  schemaless  science  scribe  scripting  scripts  search  security  semantic  semantic-web  semantic.web  semanticweb  semweb  server  sesame  shard  sharded  sharding  shards  simpledb  simplegeo  slides  slideshare  social  socialmedia  socialnetworking  socialnetworks  software  softwareengineering  solr  sparql  sql  sql-injection  sqlinjection  sqlparse  startup  statistics  stats  storage  store  subversion  svn  sysadmin  system  systems  ta  tables  tags  tech  technology  test  theorem  tips  to-read  todo  tokyo-cabinet  tokyo-tyrant  tokyocabinet  tokyotyrant  tool  tools  toread  to_read  transaction  transaction-processing  transactions  trends  triple  triple-store  triplestore  tuple  tuples  tuplespace  tutorial  tutorials  twitter  usecases  user  value  via:jacobian  video  videos  view  views  visualisation  visualization  vldb  voldemort  warehousing  washington  washingtonpost  web  web3.0  webapp  webapps  webdesign  webdev  webdevelopment  webhosting  websemantique  webservices  wiki  wikipedia  work  xfs  xmpp  yale  yam  zynga 

Copy this bookmark:



description:


tags: