How to create a server that will provide an API?

Question

API

Good time of the day! In general, I’ll get straight to the point: for study, you need to create a simple server with one database table that will provide an API and return data in JSON format , please tell me where to look, where to dig, preferably from scratch, by type:
1. Where to store database?
2. In what language to implement?
3. How to return the structure?
I didn’t list all the questions, because I don’t know what you need to know, please throw in a couple of articles, I will be very grateful for your help!
I don't know, it's important, but API requests should be iOS/Android friendly.

Answer 1

If nada is straight fast fast fast, and all this can be described as prototyping, then I would look at deployd and mongo is actually supported out of the box as a base.

Answer 2

1. mysql or sqlite
2. whichever is more convenient, I would choose php or python
3. return to json or xml
in fact, any virtual hosting with support for databases and some language, such as php, python, ruby, nodejs and etc. then you will need to create a database, fill it, and create a script that will accept requests like site.tld/?countofitems=10 and, accordingly, return data from this table (connect to the database, make a selection, convert it to json or xml).

Answer 3

Database - any. mysql/sqlite/postgres/mongodb... depends on what you store there.
Language - any. .net (mono)/java, php/python/ruby/js. If you know at least pascal - golang.
Interaction with the client (directly api) - RESTFull.

Answer 4

In your case, the easiest and fastest option is to take CouchDB, where the REST API is already implemented out of the box. You don't even have to do any programming. Here is an example of a small article in Russian.