Python for Entrepreneurs Transcripts
Chapter: Accessing databases from Python: SQLAlchemy ORM
Lecture: Popular deployments
0:03 Let's talk for a moment about some popular deployments of SQLAlchemy.
0:08 So, I think it's really important when you use a technology to see
0:12 that there are other major companies being successful with it,
0:15 often importantly beyond the realm in which you are going to use it,
0:19 so you know what you are getting into is going to scale as far as you need it to.
0:23 So let's look at what some major companies are doing with SQLAlchemy.
0:27 Dropbox is using SQLAlchemy internally, doing some really cool stuff,
0:32 remember, Dropbox is basically the center of the universe for Python
0:35 with the founder Guido van Rossum there and a bunch of the core developers,
0:40 so this is a good thing to know that they are using SQLAlchemy.
0:44 Uber, I love Uber, so much better than taxis, right, and Uber you can imagine,
0:48 this is a huge deployment that Uber has
0:52 in terms of all of their data needs, SQLAlchemy here, that's great.
0:56 Reddit, Reddit is interesting in that they use the core, not the ORM layer,
1:00 and Reddit gets a ton of traffic,
1:03 and Reddit is using SQLAlchemy, so that is really cool.
1:06 Firefox is using it, OpenStack, the open source alternative to like AWS, right,
1:13 there is huge set of tools and cloud infrastructure, those guys are using that,
1:18 Fresh Books for invoices and billing, like if you are an independent contractor,
1:23 and you want to create invoices and give them your clients,
1:27 Fresh Books, they use SQLAlchemy, that's great.
1:30 Hulu, Hulu is pretty sweet, lots of video streaming fun to be had there,
1:34 and that video streaming fun is powered by- you guessed it, SQLAlchemy.
1:38 Yelp, Yelp is pretty awesome. Triomet, shout out to the local transit
1:42 here in Portland Oregon, so that is like the buses and the trains and whatnot.
1:46 And of course, Talk Python and my related websites, like I said,
1:51 the website that you are looking at right now is powered by SQLAlchemy.
1:55 If you want to know exactly what each one of these companies is doing,
1:59 with SQLAlchemy, you can see SQLAlchemy.org/organizations.html
2:02 that link there at the bottom lists all of these companies and many more
2:06 and it actually has a paragraph or two describing
2:08 what each one of them are doing with SQLAlchemy.
2:11 So if you want to dig in even farther, go and have a look
2:14 otherwise, we are going to get started digging into the details of SQLAlchemy.