mcroydon + sql   50

Basho Riak: Schema Design and the Transition from Relational Databases
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
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
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
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
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
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
touchcode - Google Code
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
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
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
Symbian adds SQL and Location Based Services
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
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
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
Inteview with H2 Java database author
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

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:



description:


tags: