DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Please enter at least three characters to search
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Zones

Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Modernize your data layer. Learn how to design cloud-native database architectures to meet the evolving demands of AI and GenAI workkloads.

Secure your stack and shape the future! Help dev teams across the globe navigate their software supply chain security challenges.

Releasing software shouldn't be stressful or risky. Learn how to leverage progressive delivery techniques to ensure safer deployments.

Avoid machine learning mistakes and boost model performance! Discover key ML patterns, anti-patterns, data strategies, and more.

Related

  • How to Build a Full-Stack App With Next.js, Prisma, Postgres, and Fastify
  • Improving Backend Performance Part 1/3: Lazy Loading in Vaadin Apps
  • Step-by-Step Guide: Application Using NestJs and Angular
  • Develop a Secure CRUD Application Using Angular and Spring Boot

Trending

  • Develop a Reverse Proxy With Caching in Go
  • Scalable System Design: Core Concepts for Building Reliable Software
  • Fixing Common Oracle Database Problems
  • Stateless vs Stateful Stream Processing With Kafka Streams and Apache Flink
  1. DZone
  2. Data Engineering
  3. Databases
  4. Connecting Angular to an SQL database

Connecting Angular to an SQL database

Learning Angular is ridiculously difficult. Not because Angular is difficult, but because you need to teach yourself a gazillion unrelated technologies before you can create a real Angular application

By 
Thomas Hansen user avatar
Thomas Hansen
DZone Core CORE ·
Feb. 19, 21 · Tutorial
Likes (4)
Comment
Save
Tweet
Share
19.8K Views

Join the DZone community and get the full member experience.

Join For Free

Creating a "real" Angular app is ridiculously difficult, because it requires you to learn some sort of backend technology, SQL, HTTP and a gazillion other unrelated technologies. This implies that before you can create as much as a single (useful) Hello World app in Angular, you've spent the larger parts of a decade to learn unrelated technologies required to know before you can connect your Angular app to a database, and actually do something useful with your app. If you want a .Net backend for instance, you'll need to know the following.

  • C#
  • .Net class hierarchy
  • Basic OOP
  • Basic design pattern theory
  • SQL if you're using an SQL database
  • Some database theory
  • HTTP
  • Etc, etc, etc

Simply the number of classes in .Net you'll need to study, understand, and consume, rapidly becomes mind blowing. This is before you even start out with the Angular parts of your app. Sure you could create a pure Angular application, and simply ignore the server altogether - But if you do, your app is little more than fancy animations and beautifully constructed buttons, coupled inside animating navbars and tabs. If you want to create a "real" Angular app though, you'll need some sort of backend, which of course implies spending 85% of your time, on things not even remotely related to Angular in any ways what so ever. Having a real backend as you learn Angular, is also for obvious reasons a million times funnier as you start out learning.

I just had an email from a guy wanting to learn Angular frontend development, and he asked me for help. So I gave him a free license of Magic, and created an instructional video about how to get started with Angular using Magic. This implies he now has a million less things to worry about, yet still can create a real Angular app, connect it to an SQL database backend - And as he proceeds up to the point where he's good enough to maybe get a job as a frontend developer, he can use a real app as a part of his resume, and even host it for as little as $5 per month if he wants to send it to potential employers wanting to hire him. This of course would give him a huge advantage in a job interview, because the interviewer can see a real app, connected to a real backend, with an SQL database backing his Angular app, resulting in that his resume pops out compared to other people's resume.

If you came to me applying for a job as a frontend Angular developer, and all you could show for was fancy animations, navbars, and tabs - I'd probably choose somebody else. If you could show me a real Angular app, invoking a real backend, persisting data into some sort of SQL database though - I'd give your resume a second chance. However, creating a real Angular app, with a real backend, is at least 10 times as hard as creating a pure Angular app - Unless you use Magic of course. See how I created the backend in the video below.

If you're a student of Angular, and/or React for that matter, and you recognise the problem I'm describing above - I might give you a free license too, assuming you are able to convince me that you actually are a student, and you ask politely, and explain to me why you want to learn Angular software development. My reasons are obvious; There's a gazillion unemployed people on the planet today because of Covid19, looking for a different type of job, wanting to learn a craft that gives them more job security - And I've had a lot of uncertainty myself in my life, so I can empathise with your suffering. If you're dedicated enough to wanting to do this, you'll find my email address all by yourself. Hence, step 1 is as follows ...

Wax on, wax off!

AngularJS sql Database app

Opinions expressed by DZone contributors are their own.

Related

  • How to Build a Full-Stack App With Next.js, Prisma, Postgres, and Fastify
  • Improving Backend Performance Part 1/3: Lazy Loading in Vaadin Apps
  • Step-by-Step Guide: Application Using NestJs and Angular
  • Develop a Secure CRUD Application Using Angular and Spring Boot

Partner Resources

×

Comments
Oops! Something Went Wrong

The likes didn't load as expected. Please refresh the page and try again.

ABOUT US

  • About DZone
  • Support and feedback
  • Community research
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends:

Likes
There are no likes...yet! 👀
Be the first to like this post!
It looks like you're not logged in.
Sign in to see who liked this post!