TeraTech

The ColdFusion Experts: Develop | Secure | Optimize

  • Services
  • About
  • CF Alive
  • Blog
  • Podcast
  • Contact

  • Services
  • About
  • CF Alive
  • Blog
  • Podcast
  • Contact

114 Are your Database Relationships in a Rut? with Dave Ferguson

May 20, 2022 By Michaela Light Leave a Comment

Dave Ferguson talks about “Are your Database Relationships in a Rut?” in this episode of the CF Alive Podcast, with host Michaela Light.

“Perhaps we should just talk about, you know how some ColdFusion developers get stuck in a rut with their database or other pieces of CF ecosystem?

Dave Ferguson 6:54
Yeah, mostly, I mean, I would say Yeah, mostly like database specifically. Everybody, I mean, you get this happens with anybody in anything you do. When you get really good at doing one thing. People just tend to stick with it. Because it's like, that's the train just the way I know how to do something. And I'm going to do this because it just makes my life simpler. But at the same time, you're almost doing yourself a disservice, because you're not learning something new that can make your life even easier. So you don't want to have that stuck in a rut of I'm going to do, I'm gonna do the same thing at that 10. Well, you want to do the same thing over to you, you're really good at it. But getting really good at something allows you to learn something else easier then. So if you just stick to one thing, you're never going to get down that I'm going to learn something else easier, because I'm just sticking with one specific thing.”

Contents

  • Show notes
  • CF Rut?
  • What relational databases do most CFers use?
  • Is there a better way?
  • Types of database
    • Transactions pros and cons
  • Downsides of NoSQL
    • Use
    • What database type is more appropriate than others for certain data?
    • Where does using a hybrid of databases makes sense and how that would look to a system?
    • How easy is it to use alternative databases with CF 2021?
    • CAP Theorem
  • What is LearnCFinaWeek?
    • What is new at  LearnCFinaWeek?
  • Why are you proud to use CF?
  • WWIT to make CF more alive this year?
  • Mentioned in this episode
    • Bio
    • Links
  • Interview Transcript
  • Join the CF Alive revolution

Show notes

CF Rut?

  • Don’t get stuck in a CFer rut
  • Just because you have always done Try new ways too
  • Hence trying different approaches
  • Definition of “insanity”

What relational databases do most CFers use?

  • SQL Server
  • MySQL

Is there a better way?

  • Most systems don't need an elaborate, and possibly expensive, relational database. Most can get by just fine with something else. 
  • Can horizontally scale-out to accommodate large data volumes
  • Documents typically align better with code objects
  • Evolve as the app / data evolves without restructuring

Types of database

  • Hierarchical databases
  • Network databases
  • Object-oriented databases
  • Relational databases
    • Links data via Primary and Foreign
    • keys
    • Standard T-SQL query language
    • Ridged schema/structure
    • Referential Integrity (ACID)
  • NoSQL databases
    • You don't have to store your data in predetermined columns
    • each row can have a data structure the other rows don't
    • Examples
    • MongoDB
    • Apache CouchDB
    • MarkLogic
    • Azure Cosmos DB
    • Couchbase
  • Key value databases
    • (a type of NoSQL)
    • Amazon DynamoDB
    • Oracle NoSQL Database
    • InfinityDB
    • Redis
  • Wide-column Stores
    • Google Bigtable
    • Amazon DynamoDB
    • Apache Accumulo
    • Apache Cassandra
    • Apache HBase
    • Why
      • Column formatting and names vary row to row
      • Columns are stored separately on disk
      • Data searching can be faster
  • Graph Databases
    • Neo4j
    • ArangoDB
    • Dgraph
    • OrientDB
    • Amazon Neptune
    • Intensive data relationship handling. Relationships are treated as a first-class citizen
    • Structure and schema of a graph model can flex as applications and industries change
    • Database can e

Transactions pros and cons

  • Relational databases have transactions – a group of SQL statements either all succeed or are all rolled back. Is this always best for app?

Downsides of NoSQL

  • No / Minimal ACID Support
  • ACID =
    • Atomicity, Consistency, Isolation, Durability
    • ⇒ Transactions 
  • Little to no standardization between NoSQL products
  • NoSQL uses “Eventual Consistency” over transactions
  • Avoid NoSQL for
    • Banking
    • Online gaming
    • Rights Management
    • Complex / Dynamic querying

Use

  • Collection = table
    • createCollection
  • Document = row
    • objects

What database type is more appropriate than others for certain data?

Where does using a hybrid of databases makes sense and how that would look to a system?

How easy is it to use alternative databases with CF 2021?

  • ACF 2021 Package manager
  • Install MongoDB locally
  • Use MongoDB Atlas
  • DO MongoDB

CAP Theorem

  • Consistency 
    • Every node in the cluster responds with the most recent data, even if the system must block the request until all replicas update.
  • Availability 
    • Every node returns an immediate response.
  • Partition Tolerance 
    • Guarantees the system continues to operate even if a replicated data node fails or loses connectivity with other replicated data nodes.

Image2

What is LearnCFinaWeek?

  • Free learn modern CF resource
  • Key contributors
    • Dave Ferguson
    • Daniel Fredericks
    • Carl Von Stetten

What is new at  LearnCFinaWeek?

  • Learn CF in a week
  • Open source
    • CF training
    • The LearnCFinaWeek site code
  • Modernized code
    • Cfscript
    • ColdBox
  • Update for CF 2021
  • Week 2

Why are you proud to use CF?

  • It makes the hard stuff easy

WWIT to make CF more alive this year?

  • Don’t dismiss due to itself
  • Showcase what it can do with less people in faster dev cycle

Mentioned in this episode

  • CFHour
  • ACID 
  • CommandBox episode 
  • LearnCFinaWeek

 

https://traffic.libsyn.com/coldfusionalive/114_Are_your_Database_Relationships_in_a_Rut_with_Dave_Ferguson.mp3

Podcast: Play in new window | Download | Embed

Subscribe: RSS

Bio

Dave has spent the majority of his life living in sunny Southern California. Over the past almost 23 years has worked in information technology after his attempt at being a career restaurant manager failed miserably. He has spent the majority of that time specializing in large enterprise-class systems. When not writing code, Dave is an avid gamer and competitive martial artist with multiple championship titles.

Dave Ferguson

Links

  • LinkedIn
  • Twitter

Interview Transcript

Michaela Light 0:02
Welcome back to the show. I'm here with Dave Ferguson. And we're going to be talking about how your database relationships may have fallen into a rut and how to get out of sad, right so your relationships can be fabulous with your ColdFusion and database. So welcome, Dave.

Dave Ferguson 0:19
Hello, how are you?

Michaela Light 0:22
I am absolutely effing fabulous. How are you in sunny California, Southern California.

Dave Ferguson 0:28
I wish it was sunny. It is Southern California but not sunny.

Michaela Light 0:31
vakeel bio says sunny Southern California. It must be sunny

Dave Ferguson 0:36
it mostly it's sunny. But it's cold. It we're in like the cold spell right now. But it's normally pretty, pretty nice here. Can't complain.

Michaela Light 0:45
So you're somewhere south south of Los Angeles. I understand one of those amazing theme parks.

Dave Ferguson 0:50
Yes. Not not not the ones ran by the mouse. The other the other kind? The more extremes non mouse theme, the non mouse departs with extreme rise. Yes. Well, that's

Michaela Light 1:00
very appropriate than non mouse because we're going to be talking about non SQL or no SQL. So that's just a plug for what's coming up. Yep. Yes. But you've been doing it and cold fusion for decades now. Oh,

Dave Ferguson 1:16
it feels like an internal debate about how you? Yeah.

Read more

 

Dsc09151Resized

Michaela Light is the host of the CF Alive Podcast and has interviewed more than 100 ColdFusion experts. In each interview, she asks "What Would It Take to make CF more alive this year?" The answers still inspire her to continue to write and interview new speakers.

Michaela has been programming in ColdFusion for more than 20 years. She founded TeraTech in 1989. The company specializes in ColdFusion application development, security and optimization. She has also founded the CFUnited Conference and runs the annual State of the CF Union Survey.

 

 

Join the CF Alive revolution

Discover how we can all make CF more alive, modern and secure this year. Join other ColdFusion developers and managers in the CF Alive Inner Circle today.

  • Get early access to the CF Alive book and videos
  • Be part of a new movement for improving CF's perception in the world.
  • Contribute to the CF Alive revolution
  • Connect with other CF developers and managers
  • There is no cost to membership.
261913 Cfalivephoenix 2 091718
  • Facebook
  • Twitter
  • LinkedIn

Related Posts

  • ColdFusion Database Performance Tuning
  • TeraTech Development Approach - Database Review
  • 114 Are your Database Relationships in a Rut? with Dave Ferguson - Transcript
  • TeraTech Development Approach - Design in Fusebox and Database Access Components
  • 093 Learn ColdFusion in a Week with Carl Von Stetten, Daniel Fredericks and Dave Ferguson-Transcript

Filed Under: CF Alive Podcast

← Previous Post 113 ACF and Lucee roundtable with Charlie Arehart, Gert Franz, Mark Drew and Ben Nadel – Transcript
Next Post → 114 Are your Database Relationships in a Rut? with Dave Ferguson – Transcript

Subscribe on iTunes

Popular podcast episodes

  • Revealing ColdFusion 2021 – Rakshith Naresh
  • CF and Angular – Nolan Erck
  • Migrating legacy CFML – Nolan Erck
  • Adobe API manager – Brian Sappey
  • Improve your CFML code – Kai Koenig

CF Alive Best Practices Checklist

Modern ColdFusion development best practices that reduce stress, inefficiency, project lifecycle costs while simultaneously increasing project velocity and innovation.

Get your checklist

Top articles

  • CF Hosting (independent guide)
  • What is Adobe ColdFusion
  • Is Lucee CFML now better than ACF?
  • Is CF dead?
  • Learn CF (comprehensive list of resources)

Recent Posts

  • Protected: State of the CF Union 2022 Survey Released
  • 127 Modernizing ColdFusion apps (through evolution, not revolution) with Guust Nieuwenhuis
  • 126 Revealing FusionReactor 9 (ColdFusion Monitoring New Tools) with David Tattersall
  • Adobe ColdFusion 2023 Major Announcement- Codename Fortuna (Alpha, Pre- Release, Testing)
  • 125 State CF Union Survey Analysis (part 3: Community, Deployment and Wrapup) with Gavin Pickin

Categories

  • Adobe ColdFusion 11 and older
  • Adobe ColdFusion 2018
  • Adobe ColdFusion 2020 Beta
  • Adobe ColdFusion 2021
  • Adobe ColdFusion 2023
  • Adobe ColdFusion Developer week
  • Adobe ColdFusion Project Stratus
  • Adobe ColdFusion Summit
  • AWS
  • CF Alive
  • CF Alive Podcast
  • CF Camp
  • CF Tags
  • CF Vs. Other Languages
  • CFEclipse
  • CFML
  • CFML Open- Source
  • CFUnited
  • ColdBox
  • ColdFusion and other news
  • ColdFusion Community
  • ColdFusion Conference
  • ColdFusion Consulting
  • ColdFusion Developer
  • ColdFusion Development
  • ColdFusion Hosting
  • ColdFusion Maintenance
  • ColdFusion Performance Tuning
  • ColdFusion Projects
  • ColdFusion Roadmap
  • ColdFusion Security
  • ColdFusion Training
  • CommandBox
  • Docker
  • Fixinator
  • Frameworks
  • Fusebox
  • FusionReactor
  • IntoTheBox Conference
  • Java
  • JavaScript
  • JVM
  • Learn CFML
  • Learn ColdFusion
  • Legacy Code
  • Load Testing
  • Lucee
  • Mindmapping
  • MockBox
  • Modernize ColdFusion
  • Ortus Developer Week
  • Ortus Roadshow
  • Server Crash
  • Server Software
  • Server Tuning
  • SQL
  • Survey
  • Survey results
  • TestBox
  • Transcript
  • Uncategorized
  • Webinar
  • Women in Tech
  • Home
  • Services
    • ColdFusion Consulting
    • ColdFusion Development
    • ColdFusion Maintenance
    • ColdFusion Security
  • About Us
  • CF Alive
    • CF Alive Book
    • CF Alive Inner Circle
    • CF Alive full resources cheatsheet
  • Blog
  • Podcast
    • Podcast Guest schedule
  • Contact
  • Sitemap

The ColdFusion Experts:
Develop, Secure, Optimize

TeraTech Inc
451 Hungerford Drive Suite 119
Rockville, MD 20850

Tel : +1 (301) 424 3903
Fax: +1 (301) 762 8185

Follow us on Facebook Follow us on LinkedIn Follow us on Twitter Follow us on Pinterest Follow us on YouTube

 

(Gandalf, the CF wizard,

can often be found in Hobbiton)

Copyright © 1998–2023 TeraTech Inc. All rights Reserved.