Kotlin with Ktor 04 - Implementing Exposed for Database Connections

Persisting data in some sort of database is always a requirement when building out essential applications. In this video, I'm going to go over installing JetBrains Exposed library for connecting to databases. We will be using the H2 in-memory option to keep this as simple as possible.

To demonstrate utilizing the database, we are going to create a table. Insert some default data rows. Use a GET method to fetch all the records, a GET method to retch a specific record by ID and a POST method to insert a new row inside the database. We will be using curl inside the terminal for both our GET and POST methods.

Links:

[prathameshmore]

This video is to the point. Your search for Ktor + Exposed will end here.

[geoffl]

I've been stuck due to a gradle version mismatch for ~2 days.

Watching your video got me to try exactly what's in the directions.

Surprise-it worked.

Thanks man!

[ShaynPutnam]

Thanks so much. I was looking for this much info on the github site for exposed and found it lacking. Really cleared some things up for me.

[anjith]

Damn, what I found interesting is you didn't make a single mistake. I meant no compile time error or logical error even when using VS Code. 🤷🏻‍♀️ I like this series of videos. I would really appreciate if you keep up this series. Thanks a lot.

[noahancolie]

Excellent video. Nice speach. Thank you ! :)

[jamil]

Thank you so much for this tutorial!! looking forward to more videos on the topic in the future!

[ivankljun]

Very nice tutorial, thank you for this!

[bencekovacs]

Hey! If you could talk a bit more about this topic I'd be glad to watch. Something that's not as easy as yeah okay we create a table, and insert some stuff into it, but cover updating, foreign keys, whatever.

[svetopolk]

Hi John, thank you very much, you are my hero, it is very useful.
Are you going to explain what (and how) is needed for?

[galaxiegalaxie]

What should we do for complex join query that is very long

[codewithkael]

greetings,
why when we restart server, all of our data will be lost ?