Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases

Matthew Francis
Matthew Francis
6,967 Points

How can I create an API using my SQL database?

Recently created a database about dogs in MySQL; how do I create an API so that I can transfer that data into my Android App? Do I need to learn any other langanges to create my own API? if so, what other languages are they? (I've heard about Maven and Rails are related to API creation?)

2 Answers

Erik Krieg
Erik Krieg
43,038 Points

I believe you can use just about any server-side language to build an API.

Here are some tutorials for different server-side languages that you can find on Treehouse:

Many of these tutorials do have prerequisite courses, so be sure to give yourself the proper foundation before diving in.

Matthew Francis
Matthew Francis
6,967 Points

Thanks! Where did you find these course? I can't seem to find them in Tracks..

Also is there an "advanced SQL course"?

Erik Krieg
Erik Krieg
43,038 Points

I found these courses by from the Library page. You can filter for courses from various topics on that page.

There is not a general "advanced" SQL course but you can find all the database courses here, many of which are related to SQL. There is also a short track for SQL that arranges some of these courses in a logic order.

Matthew Francis
Matthew Francis
6,967 Points

Thanks Erik! I have another pondering question

I created a student database for a university through MySQL . I want the database be retrivable through my app. So now I need to create an API to do so.

My question is, should I use PHP, Spring or Ruby on Rails to create the API? I've heard Ruby on Rails is fine for simple CRUD operations. And Spring is used for more complicated back-end logic (like what? an example would be great). For my app, I need to update it every few months since the number of students keeps on changing; should I use Spring or RoR?

Erik Krieg
Erik Krieg
43,038 Points

Well, sounds like CRUD will probably cover all the operations you will need. I personally have not worked with either RoR or Spring, but RoR is well know for promoting good conventions which makes it an especially good option for newer developers.

If there is a scripting language you feel most comfortable with then I think finding a framework for that language is a good way to go. If you are interested in learning something new RoR is probably your best option here.