RSS

mcroydon + mysql   59

Code: Flickr Developer Blog » The Code Behind Geofences
Behind the curtain on Flickr's new geofences feature.
flickr  geo  mysql  privacy 
september 2011 by mcroydon
Cinderella - A Development Environment for Macs
Interesting take on a multilanguage development environment.
homebrew  administration  chef  configuration  development  environment  node  mongodb  mysql  mongo  memcached  mac  node.js  open  opensource  osx  os  postgresql  programming  x  source  tools  sinatra  rubyonrails  ruby  rvm 
september 2010 by mcroydon
Piwik - Web analytics - Open source
Open source analytics built on PHP/MySQL.
analysis  analytics  chart  charts  development  free  software  php  opensource  open  mysql  monitoring  source  statistics  stats  webdev  tool  tools  tracking  traffic  visualization  website  webdesign  web2.0  web 
may 2010 by mcroydon
NoSQL vs. RDBMS: Let the flames begin! – stu.mp
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
Jonathan Ellis's Programming Blog - Spyced: Cassandra in action
Quite the Cassandra roundup.
cassandra  cloudkick  database  db  digg  hadoop  example  read  programming  nosql  mysql  lucene  kvs  key-value  hbase  reddit  scalability  scaling  sql  storage  toread  twitter 
march 2010 by mcroydon
Saying Yes to NoSQL; Going Steady with Cassandra | Digg About
Digg goes all-in with Cassandra.
cassandra  database  digg  mysql  nosql  review  scribe  socialnetworking 
march 2010 by mcroydon
Notes from a production MongoDB deployment « Boxed Ice Blog
This seems like an awful lot of work for a relatively small document set.
2read  architecture  couchdb  database  databases  datacenter  linux  experience  distributed  development  deployment  db  mongo  mongodb  mysql  notes  nosql  performance  production  software  sharding  server  scalability  replication  programming  sysadmin  to_read  tips  web 
march 2010 by mcroydon
HBase vs. Cassandra: NoSQL Battle! | Road to Failure
Someone who chose HBase over Cassandra (and why).
amazon  architecture  article  bigdata  bigtable  blog  cap  computing  comparison  compare  clustering  cassandra  database  development  dht  distributed  foss  grid  hadoop  scalability  research  nosql  mysql  hbase  post  vs 
march 2010 by mcroydon
HBase vs Cassandra: why we moved « Bits and Bytes.
A look at someone who started with HBase and moved to Cassandra (and why).
architecture  benchmark  article  blog  cap  cassandra  cloud  development  database  db  computer  foss  comparison  compare  distributed  hadoop  hbase  mysql  nosql  performance  toread  scalability  programming  consistency 
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
What every developer should know about database scalability, PyCon 2010
Looks like a fantastic deck.
python  database  dev  distributed  scaling  mysql  cache  memcached  nosql  mongodb 
february 2010 by mcroydon
Fixing Poor MySQL Default Configuration Values (by Jeremy Zawodny)
Defaults you shouldn't run with in a high-traffic environment.
web  database  dev  performance  work  mysql  configuration  config 
november 2009 by mcroydon
Graphs in the database: SQL meets social networks – techPortal
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
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
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
HadoopDB Project
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
GPS Tracking: Open-Source GPS Tracking System - OpenGTS
Open source fleet tracking software.
programming  mobile  web  software  linux  maps  code  mapping  gis  free  java  opensource  server  gps  geo  framework  embedded  mysql  location  j2me  tracking  system  navigation  lbs  monitoring  googlemaps  gprs  opengts  opendmtp  fleet 
july 2009 by mcroydon
Should you go Beyond Relational Databases? | Think Vitamin
Includes links to a bunch of graph databases too.
programming  development  web  data  reference  database  toread  technology  opensource  dev  scalability  storage  work  hadoop  article  graph  databases  mysql  nosql  keyvalue  bigtable  rdbms  resource  reading  couchdb  comparison  db  mapreduce  relational  alternative 
july 2009 by mcroydon
braindump: NOSQL debrief
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
Sequoia
"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
Slides from "MySQL and Search at Craigslist" (by Jeremy Zawodny)
A nice peek at what makes Craigslist tick.
video  search  scalability  presentation  mysql  optimization  slides  slide  craigslist  sphinx 
april 2009 by mcroydon
Paul Ramsey: OpenStreetMap moves to PostgreSQL
The OSM folks come around to Postgres.
maps  free  opensource  postgresql  mysql  postgres  comparison  osm 
april 2009 by mcroydon
Some Notes on Distributed Key Stores « random($foo)
Yeah, the Tokyo stack appears to rocketh.
data  database  blog  scalability  storage  distributed  scaling  databases  ec2  mysql  cloud  dht  hash  key-value  rdbms  tokyocabinet  keyvalue  cassandra  tokyotyrant  voldemort  keystore 
april 2009 by mcroydon
peeping into memcached :: snax
Interesting technique for checking in on your memcached server. Could prove quite useful in cache-related troubleshooting.
programming  development  tools  webdev  scalability  architecture  memcached  mysql  article  optimization  twitter  stats  debugging  memcache  monitoring  peep 
april 2009 by mcroydon
Anti-RDBMS: A list of distributed key-value stores | Richard Jones, Esq.
Great list of stuff worth poking at.
programming  development  data  database  erlang  scalability  storage  architecture  distributed  performance  databases  mysql  memcached  list  comparison  cloud  scalaris  keyvalue  rdbms  hbase  dynamo  key-value  bigtable  dht  simpledb  couchdb  db  store  voldemort  hypertable 
march 2009 by mcroydon
How FriendFeed uses MySQL to store schema-less data - Bret Taylor's blog
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
Tokyo Dystopia: a full-text search system
Interesting.
development  database  library  search  tech  text  mysql  c  lucene  indexing  engine  ir  searchengine  tokyo  informationretrieval  fulltext  tokyocabinet  searching  全文検索 
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
Sphinx Search with PostgreSQL at Matt Croydon::Postneo
The one where I get off my butt and actually post something.
sphinx  search  index  indexing  mysql  postgresql  database  information-retrieval 
february 2009 by mcroydon
High-Performance Click Analysis with MySQL | MySQL Performance Blog
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
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
DVPmysqlucFederation at Flickr: Doing Billions of Queries Per Day
I think I sharded a little.
shard  sharded  programming  database  sysadmin  architecture  presentation  scalability  scaling  flickr  performance  mysql  databases  optimization  sharding  federation  shards  ops 
august 2008 by mcroydon
Amazon Web Services Developer Connection : Running MySQL on Amazon EC2 with Elastic Block Store
This applies pretty cleanly to other database engines too.
reference  database  howto  toread  tutorial  amazon  sysadmin  storage  s3  aws  scalability  computing  ec2  databases  mysql  webhosting  cloud  article  tutorials  cloudcomputing  ebs  xfs  webservices 
august 2008 by mcroydon
Scalable Web Architectures: Common Patterns and Approaches
Nice deck, though less new information each time I read a similar deck.
sysadmin  architecture  scalability  scaling  flickr  mysql  performance  deployment  optimization  slides  patterns  pattern  slide  availability  arquitectura  scalable  slideshow  ha 
august 2008 by mcroydon
How I Learned to Stop Worrying and Love Using a Lot of Disk Space to Scale | High Scalability
I need to finish reading this.
database  development  mysql  scalability  scaling  server  someday  @toread 
may 2008 by mcroydon
Exploring Amazon EC2 for Scale-out Applications
Good slide deck on EC2 and what's changing.
amazon  architecture  benchmark  aws  ec2  benchmarks  filesystem  mysql  performance  scalability  storage  scaling  xen 
april 2008 by mcroydon
Diamond Notes » Scaling MySQL - - Up or Out? Panel @ UC
Interesting numbers among some pretty big sites.
architecture  database  httpd  mysql  os  performance  scalability  scaling  server  servers  statistics  stats  web 
april 2008 by mcroydon
Маниакальный Веблог » Why “Where everyone goes” crashed
There's nothing like performance tuning under pressure.
deployment  django  interesting  memcached  mysql  optimization  python  webdev  scaling 
february 2008 by mcroydon
Odd MySQL bug -
The punchline is fantastic.
bug  funny  mysql 
december 2007 by mcroydon
Joe Gregorio | BitWorking | NYTimes DBSlayer
NYT gets the code out.
http  json  open-source  mysql  database 
october 2007 by mcroydon
caboose Scale rails from one box to three, four and five
Seems smart from here.
architecture  blog  cache  caching  cluster  database  deployment  dev  development  howto  linux  mongrel  mysql  optimization  programming  parallel  rails  ruby  scalability  scaling  sysadmin  server  toread  vps  tutorial  web  webdev 
july 2007 by mcroydon
OpenSyncro, opensource EAI software for Java, Tomcat & MySQL platform
"OpenSyncro is a lightweight, open source enterprise application integration tool written in Java language. It runs on Apache Tomcat application server and stores its configuration data in MySQL database." Lightweight?!?!?
integration  java  library  mysql  tomcat 
july 2007 by mcroydon
Caoyuan's Blog : Weblog
This is insane and hurts my head.
erlang  mysql  programming  webdev  geowanking  geolocation  gis 
july 2007 by mcroydon
S3 + Rake = Easy Backups for SVN Repositories, Databases, and Code
A great way to back up using ruby and rake.
amazon  backup  aws  capistrano  code  database  development  ec2  interesting  mysql  programming  rails  ruby  s3  scripting  subversion  svn  sysadmin  utilities 
may 2007 by mcroydon
Amazon Web Services Blog: MySQL Interface to Amazon S3
Pretty wicked hack.
amazon  aws  database  databases  dev  ec2  hack  interface  mercurial  mysql  s3  software  storage  webdev 
april 2007 by mcroydon
Page2RSS: PostgreSQL vs. MySQL Performance
"That sharp drop in the middle of December is when we switched to the PostgreSQL."
databases  development  mysql  postgres  postgresql  programming 
january 2007 by mcroydon
The Pochi Superstar Mega Show! » Projects
Working with geo datatypes (PostGIS, etc) in Ruby.
gis  mapping  maps  mysql  postgresql  postgis  rails  ruby 
january 2007 by mcroydon
database-independence: it has begun.
Did someone say Mogilefs and postgres?
mysql  postgres  mogilefs  mogile  perl  perlbal 
december 2006 by mcroydon
PostgreSQL for MySQL users | Linux Box Admin
Postgres for MySQL heads.
database  mysql  postgresql  server  sql 
december 2006 by mcroydon
MySQL: Search & Replace (UrbanMainframe.com)
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
lighttpd support? « WordPress Support
This is how I'm doing WP on PHP5 and MySQL5 on lighttpd via fastcgi.
php  lighttpd  wordpress  wp  fastcgi  mysql 
december 2006 by mcroydon
MySQL Backups
Hey, it's that simple?
backup  mysql 
december 2006 by mcroydon
Spyced: Benchmark: PostgreSQL beats the stuffing out of MySQL: Jonathan's Python Blog
Go Postgres, Go!
benchmark  benchmarks  database  databases  mysql  postgres  postgresql  programming 
december 2006 by mcroydon
Lighty Rocks My PHP/MySQL World at Matt Croydon::Postneo 2.0
I finally got around to writing up the KUSports boards migration.
lighttpd  php  mysql 
march 2006 by mcroydon
whenpenguinsattack.com: mysql vs postgres
The lone "No" in the Postgres list (and this is 7,x, not the current 8.x) can be replaced with "Yes" if you use PostGIS.
database  mysql  postgresql  postgres 
february 2006 by mcroydon
YourSQL
Sexy little mysql administration tool for OSX
mac  osx  development  database  mysql 
july 2005 by mcroydon
Source Labs | AMPStack
I hope that this isn't all they've got.
open-source  lamp  apache  php5  mysql 
march 2005 by mcroydon
opensourceCMS.com
Taking a spin with open source content management systems
cms  mysql  open-source  php 
october 2004 by mcroydon
Jeffrey Veen: Making A Better Open Source CMS
Very interestin read, via Column Two.
cms  mysql  open-source  php 
october 2004 by mcroydon

related tags

2read ⊕  @toread ⊕  acm ⊕  ad ⊕  admin ⊕  administration ⊕  advice ⊕  algorithms ⊕  alternative ⊕  amazon ⊕  analysis ⊕  analytics ⊕  apache ⊕  architecture ⊕  arquitectura ⊕  article ⊕  availability ⊕  aws ⊕  backup ⊕  benchmark ⊕  benchmarks ⊕  bigdata ⊕  bigtable ⊕  blob ⊕  blog ⊕  bug ⊕  bugs ⊕  c ⊕  c# ⊕  cache ⊕  caching ⊕  cap ⊕  capistrano ⊕  cassandra ⊕  chart ⊕  charts ⊕  chef ⊕  click ⊕  cloud ⊕  cloudcomputing ⊕  cloudkick ⊕  cluster ⊕  clustering ⊕  cms ⊕  code ⊕  coding ⊕  compare ⊕  comparison ⊕  computer ⊕  computing ⊕  conference ⊕  config ⊕  configuration ⊕  consistency ⊕  cost ⊕  couchdb ⊕  craigslist ⊕  data ⊕  database ⊕  databases ⊕  datacenter ⊕  datamining ⊕  datastructures ⊕  datawarehouse ⊕  db ⊕  dbms ⊕  debug ⊕  debugging ⊕  decisions ⊕  deployment ⊕  design ⊕  dev ⊕  development ⊕  dht ⊕  digg ⊕  distributed ⊕  django ⊕  domain ⊕  dynamo ⊕  dynomite ⊕  ebs ⊕  ec2 ⊕  embedded ⊕  engine ⊕  english ⊕  environment ⊕  erlang ⊕  example ⊕  experience ⊕  facebook ⊕  fastcgi ⊕  federation ⊕  filesystem ⊕  find ⊕  fleet ⊕  flickr ⊕  foss ⊕  framework ⊕  free ⊕  friendfeed ⊕  fulltext ⊕  fun ⊕  funny ⊕  geek ⊕  geo ⊕  geolocation ⊕  geowanking ⊕  gis ⊕  googlemaps ⊕  gprs ⊕  gps ⊕  graph ⊕  graphs ⊕  grid ⊕  ha ⊕  hack ⊕  hacking ⊕  hacks ⊕  hadoop ⊕  hadoopdb ⊕  hash ⊕  hbase ⊕  highavailability ⊕  hive ⊕  homebrew ⊕  howto ⊕  http ⊕  httpd ⊕  hypertable ⊕  import ⊕  index ⊕  indexing ⊕  information-retrieval ⊕  informationretrieval ⊕  injection ⊕  integration ⊕  interesting ⊕  interface ⊕  ir ⊕  j2me ⊕  java ⊕  jdbc ⊕  json ⊕  key-value ⊕  keystore ⊕  keyvalue ⊕  kvs ⊕  kvstore ⊕  lamp ⊕  lbs ⊕  lesen ⊕  library ⊕  lighttpd ⊕  linkedin ⊕  linux ⊕  list ⊕  location ⊕  lucene ⊕  mac ⊕  make ⊕  management ⊕  map-reduce ⊕  mapping ⊕  mapreduce ⊕  maps ⊕  memcache ⊕  memcached ⊕  mercurial ⊕  mobile ⊕  mogile ⊕  mogilefs ⊕  mongo ⊕  mongodb ⊕  mongrel ⊕  monitoring ⊕  mysql ⊖  navigation ⊕  neat ⊕  network ⊕  networks ⊕  node ⊕  node.js ⊕  nosql ⊕  notes ⊕  open ⊕  open-source ⊕  opendmtp ⊕  opengts ⊕  opensource ⊕  ops ⊕  optimization ⊕  os ⊕  osm ⊕  osx ⊕  parallel ⊕  pattern ⊕  patterns ⊕  peep ⊕  performance ⊕  perl ⊕  perlbal ⊕  php ⊕  php5 ⊕  post ⊕  postgis ⊕  postgres ⊕  postgresql ⊕  presentation ⊕  privacy ⊕  production ⊕  profile ⊕  profiler ⊕  programming ⊕  python ⊕  query ⊕  rails ⊕  rdbms ⊕  read ⊕  reading ⊕  realtime ⊕  reddit ⊕  reference ⊕  relational ⊕  replication ⊕  reporting ⊕  research ⊕  resource ⊕  review ⊕  ruby ⊕  rubyonrails ⊕  rvm ⊕  s3 ⊕  scalability ⊕  scalable ⊕  scalaris ⊕  scaling ⊕  schema ⊕  schema-less ⊕  schemaless ⊕  scribe ⊕  scripting ⊕  search ⊕  searchengine ⊕  searching ⊕  security ⊕  seo ⊕  server ⊕  servers ⊕  shard ⊕  sharded ⊕  sharding ⊕  shards ⊕  simpledb ⊕  simplegeo ⊕  sinatra ⊕  slide ⊕  slides ⊕  slideshow ⊕  social ⊕  socialnetworking ⊕  socialnetworks ⊕  software ⊕  solr ⊕  someday ⊕  source ⊕  sphinx ⊕  sql ⊕  sql-injection ⊕  sqlinjection ⊕  statistics ⊕  stats ⊕  storage ⊕  store ⊕  subversion ⊕  svn ⊕  sysadmin ⊕  system ⊕  tables ⊕  tech ⊕  technology ⊕  test ⊕  text ⊕  tips ⊕  to-read ⊕  tokyo ⊕  tokyocabinet ⊕  tokyotyrant ⊕  tomcat ⊕  tool ⊕  tools ⊕  toread ⊕  to_read ⊕  tracking ⊕  traffic ⊕  trends ⊕  tutorial ⊕  tutorials ⊕  twitter ⊕  utilities ⊕  via:jacobian ⊕  video ⊕  videos ⊕  visualization ⊕  vldb ⊕  voldemort ⊕  vps ⊕  vs ⊕  warehouse ⊕  web ⊕  web2.0 ⊕  webdesign ⊕  webdev ⊕  webdevelopment ⊕  webhosting ⊕  webservices ⊕  website ⊕  wordpress ⊕  work ⊕  wp ⊕  x ⊕  xen ⊕  xfs ⊕  yale ⊕  全文検索 ⊕ 

Copy this bookmark:



description:


tags: