Download
News
- SmoothLife - Floating point game of life
- Twitter open sources mobile A/B testing
- Cheating on Coursera
- Jason: Pixen http://www.pixen.com
- Patrick: DownCast http://www.downcastapp.com/
Query Languages
History
- SQL
- Used to query databases
- SPARQL
- Used to query semantic webs
Features
- Can be interfaced from multiple different systems
- Can be Transactional
Strengths
- Designed to handle large amount of data efficiently
Weaknesses
- Relational vs Non Relational
- Maintenance Costs
- SQL Database Engines
- SQLite, Mysql, postgresql
- NoSQL query languages
- HiveQL, CassandraQL
- SPARQL Engines
- SPARQL Engine (Java)
Uses
- Web Projects
- wordpress, django, phpbb
- Semantic Web Analysis
- dbpedia (semantic web version of wikipedia)
I love your show and usually listen it trough a podcast APP.
ReplyDeleteThis is the first time i go to the site and i have one remark.
A grey download text in the grey background make it really hard to find.
Awesome show guys! I just started listening a few days ago to this episode and it got me thinking about how I am structuring a database for a project I am working on. I was wondering if you could cover a few topics a bit further in detail for SQL databases: Triggers and Creating a secure log-in within SQL.
ReplyDeleteThanks and keep up the great work!
Jake