recentpopularlog in

garrettc : database   61

Monica lets you remember everything about your loved ones.
crm  family  personal  opensource  software  database  friends 
12 weeks ago by garrettc
Select Star SQL
“An interactive book which aims to be the best place on the internet for learning SQL. It is free of charge, free of ads and doesn't require registration or downloads. It helps you learn by running queries against a real-world dataset to complete projects of consequence. It is not a mere reference page — it conveys a mental model for writing SQL.”
SQL  tutorial  database  programming  learning  education 
september 2018 by garrettc
"GeoMesa is an open source suite of tools that enables large-scale geospatial querying and analytics on distributed computing systems. GeoMesa provides spatio-temporal indexing on top of the Accumulo, HBase, Google Bigtable and Cassandra databases for massive storage of point, line, and polygon data. GeoMesa also provides near real time stream processing of spatio-temporal data by layering spatial semantics on top of Apache Kafka. Through GeoServer, GeoMesa facilitates integration with a wide range of existing mapping clients over standard OGC (Open Geospatial Consortium) APIs and protocols such as WFS and WMS. GeoMesa supports Apache Spark for custom distributed geospatial analytics."
database  geodata  gis  opensource 
june 2018 by garrettc
One command to generate REST APIs for any MySql Database.
nodejs  mysql  rest  restful  database  api  webdevelopment  javascript 
june 2018 by garrettc
Database Flow
"Database Flow is an open source self-hosted SQL client, GraphQL server, and charting application that works with your database. Visualize schemas, query plans, charts, and results. You can run Database Flow locally for your own use, or install to a shared server for the whole team."
database  tool  devops  mysql  postgresql  sqlite 
april 2018 by garrettc
Every record shop in the world
recordshop  geodata  mapping  shopping  database 
november 2017 by garrettc
Interactive Database of the World's River Basins
"This database provides the first-ever compilation of the world’s river basins developed specifically for corporate disclosure. It features a comprehensive list of river basins worldwide, including their names, boundaries, and other helpful information."
database  geography  reference  world  rivers  geodata  map  environment 
november 2017 by garrettc
Make Your Company Data Driven | Redash
Use Redash to connect to any data source (Redshift, BigQuery, MySQL, PostgreSQL, MongoDB and many others), query, visualize and share your data to make your company data driven.
dashboard  analytics  database  datamining  visualisation  opensource 
october 2017 by garrettc
Supercook: recipe search by ingredients you have at home
Supercook is a recipe search engine that lets you search by ingredients you have at home. Find thousands of recipes you can make right now with the ingredients you have available at home. Supercook can help you save hundreds on grocery bills by showing you how to fully use the ingredients you have at home. No more wasted left-overs. Asian,Breads,Breakfast,Cakes,Caribbean,Casseroles,Cookies,Desserts,Dinner,Dips,Drinks,Fish recipes,Grilling & BBQ,Indian & Thai,Italian,Kid Friendly,Meat recipes,Mediterranean,Mexican,Poultry recipes,Quick & Easy,Salad Dressings,Salads,Sandwiches,Sauces,Seafood recipes,Slow Cooker,Soups,Veggie recipes
cooking  food  recipes  search  database 
august 2017 by garrettc
PouchDB & CouchDB: An interview with Nolan Lawson
"With so many databases out there to choose, it’s hard to know which one will work best with your project’s infrastructure. Nolan Lawson, software developer and core maintainer of the popular JavaScript database PouchDB, understands firsthand the importance of examining a database’s tradeoffs before implementing it into your stack. He recently offered us some of his database insights."
database  technology  internet  worldwideweb  pouchdb  couchdb 
april 2017 by garrettc
Tableau Software
Tableau can help anyone see and understand their data. Connect to almost any database, drag and drop to create visualizations, and share with a click.
business  data  database  tools  visualisation 
january 2017 by garrettc
A simple and lightweight SQL client desktop/terminal
with cross database and platform support.
database  sql  tools  opensource 
august 2016 by garrettc
A beginner’s guide to ACID and database transactions
Introduction Transactions are omnipresent in today's enterprise systems, providing data integrity even in highly concurrent environments. So let's get started by first defining the term and the context where you might usually employ it. A transaction is a collection of read/write operations succeeding only if all contained operations succeed. Inherently a transaction is characterized by…
database  programming 
august 2016 by garrettc
Open-source bulk data loader that helps data transfer between various databases, storages, file formats, and cloud services.
csv  database  migration  data  sql 
may 2016 by garrettc
Kinto is a lightweight JSON storage service with synchronisation and sharing abilities. It is meant to be easy to use and easy to self-host.

Kinto is used at Mozilla and released under the Apache v2 licence.
api  data  database  json  webdevelopment  javascript 
december 2015 by garrettc
Airtable works like a spreadsheet crossed with a database. It's somewhat like Access on the web.
database  spreadsheet  collaboration  tools  saas  productivity  data 
october 2015 by garrettc
Importing huge databases faster
Use parallel processing to save time importing databases.
drupal  drush  database 
april 2015 by garrettc
InfluxDB - Open Source Time Series, Metrics, and Analytics Database
An open-source, distributed, time series database
with no external dependencies.
analytics  database  metrics  monitoring 
march 2015 by garrettc
Visual Guide to NoSQL Systems
"There are so many NoSQL systems these days that it's hard to get a quick overview of the major trade-offs involved when evaluating relational and non-relational systems in non-single-server environments."
comparison  database  nosql  sql  riak  mysql  postgresql  cassandra  couchdb  redis  berkeleydb 
december 2014 by garrettc
Tuning your Drupal database for data migration
Configuration options for better performing migrations.
drupal  migration  mysql  database  performance 
april 2014 by garrettc
Personal names around the world
If you've ever fretted over name fields in a form for international audiences, this isn't watertight, but it is good:
ethnographics  culture  society  database  programming  bestpractice  software  names  internationalisation  localisation 
march 2014 by garrettc
Use The Index, Luke!
A free tutorial covering SQL indexing and SQL tuning for developers
book  database  mysql  sql  performance  sysadmin 
december 2012 by garrettc
An Open Source hosted geospatial platform. Supports visualising data on Google Maps, Mapbox tiles, Open Street Maps and many others.
database  geo  geolocation  location  maps  mapping  geodata  analysis  wdcs  gis 
april 2012 by garrettc
The NoSQL movement
How to think about choosing a database.
database  nosql  mongodb  couchdb 
february 2012 by garrettc
Linked data repository.
data  linkeddata  opendata  rdf  database 
august 2011 by garrettc
the Data Hub
CKAN, the Comprehensive Knowledge Archive Network, a registry of open knowledge packages and projects.
data  database  opensource  opendata  mashup  reference 
july 2011 by garrettc
MySQL and Postgres command equivalents
I'm delving into a lot more Postgres, and I'm getting confused.
mysql  postgresql  database  reference  sql 
january 2011 by garrettc
Amazingly comprehensive mobile device specs library.
browser  database  development  mobile  phone  reference  research  device  webdevelopment  jquery 
november 2010 by garrettc
A power tool for working with messy data, cleaning it up, transforming it from one format into another and extending it with web services
google  data  opensource  analysis  database  software  semanticweb  wdcs  torchboxshowandtell  wdcsintranet  tools 
november 2010 by garrettc
Mr. Data Converter
Will convert your Excel data into one of several web-friendly formats, including HTML, JSON, XML, PHP, Python dict and many more
data  xml  json  conversion  php  database  excel  csv  python  torchboxshowandtell  tools 
november 2010 by garrettc
Virtual Mitchell
An huge collection of photographs of Glasgow from the Mitchell library which covers the last 150 years of the city's history
history  library  photography  database  literature 
february 2010 by garrettc
World Government Data
The one-stop shop for World Government datasets from The Guardian.
data  statistics  government  opendata  database  research 
january 2010 by garrettc
Useful temporal functions & queries
A collection of some common and useful time & date calculations and equations.
mysql  sql  time  date  tips  database  programming  reference  tricks 
december 2009 by garrettc
Module-In-A-Box: We Built Admin Tools So You Don't Have To
Scaffolding module for Drupal that takes a lot of the headache out of building modules that require data storage
database  development  documentation  drupal  useful  module 
june 2008 by garrettc
SQL joins explained with a venn diagram
"If you have tried to understand how joins work and constantly get confused about what join to use, you just need to keep a simple picture in mind"
cheatsheet  database  mysql  diagram  guide  howto  illustration  infographics  teaching  useful  programming  sql 
october 2007 by garrettc
'Sitefinder' Mobile Phone Base Station Database
Technical details and locations of cellular operator's phonemasts.
database  geo  interesting  location  mobile  phone  science  mapping 
october 2007 by garrettc
Quick wins with MySQL
Useful quick tricks for getting MySQL to run a little better.
database  mysql  performance  sql  optimisation  tips 
september 2007 by garrettc
"...contains over eight million geographical names and consists of 6.5 million unique features whereof 2.2 million populated places and 1.8 million alternate names."
community  creativecommons  data  database  research  resource  location  geotagging  gis  geocoding  geo  api  software  tagging  useful  webdevelopment  maps 
may 2007 by garrettc
MySQL my.cnf configuration for a large Drupal site
Example MySQL configuration from Ubuntu (Debian based) for a Drupal site serving hundreds of thousands of pages a day.
drupal  reference  mysql  database  scaling  webdevelopment 
march 2007 by garrettc

Copy this bookmark:

to read