Hands-On Restful Web services with Go by Naren Yellavula

Author:Naren Yellavula [Naren Yellavula]
Language: eng
Format: epub
Tags: COM051010 - COMPUTERS / Programming Languages / General, COM060180 - COMPUTERS / Web / Web Services and APIs, COM060160 - COMPUTERS / Web / Web Programming
Published: 2020-02-28T13:37:04+00:00

It returns the following JSON code:

{

"url":"https://www.packtpub.com/eu/game-development/unreal-engine-4-shaders-and-effects-cookbook"

}

So, the service can use this result to redirect the user to the original URL (site). Here, the generated string doesn't depend on the length of the URL because the database ID is the only criterion for encoding.

The package imports in urlshortener are left out, for brevity. Please refer to the project code from the chapter7 GitHub repository.

The RETURNING keyword needs to be added to the INSERT SQL command in PostgreSQL to fetch the last inserted database ID. This is not the case with the MySQL or SQLite3 INSERT INTO web_url( ) VALUES($1) RETURNING id, record.URL query. This database query returns the last inserted record's ID. If we drop that RETURNING keyword, the query returns nothing.

In the next section, we'll look at an important feature of PostgreSQL called JSONStore. PostgreSQL, unlike other relational databases, can allow JSON to be stored in the form of fields. It also provides a query language for JSON.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.