How to implement web application architecture?

B

B1ackGh0st2017-05-30 08:30:37

PHP

B1ackGh0st, 2017-05-30 08:30:37

Hello.
I'm trying to study in depth the Vedas of technology and a couple of questions arose. For myself, I set a goal to create an ad platform on a localhost similar to avito (Purely for experience, nothing else comes into my head).
Question_0: how is the table of added ads tripled there? Is there a different table for each category of ads (cars/apartments)? Or is postgresql used as the main tables (users, categories, subcategories, comments), and the added declarations themselves are in mongoDB?
Question_1: Where can I read about creating complex web applications?

Reply

Answer the question

In order to leave comments, you need to log in

5 answer(s)

X

xmoonlight, 2017-05-30
@xmoonlight

mysql >=5.7 property sets in json format in table cells with native access.
See and use.

I

Ilya, 2017-05-30
@rpsv

You need to read not about "complex web applications", but about the architecture of the database.
Here are a couple of articles:
https://docs.microsoft.com/ru-ru/azure/documentdb/...
https://habrahabr.ru/company/ruvds/blog/324936/
https://habrahabr.ru/post /322532/

A

Alexander Shapoval, 2017-05-30
@AlexanderShapoval

Building a complex web application starts with database design. then select the instrument. I don't recommend writing from scratch. I recommend choosing Laravel or OctoberCMS if you don’t want to bother with the admin panel

B

B1ackGh0st, 2017-05-30
@B1ackGh0st

Okay, I see....
Is it possible to implement autoincrement id inside a document in mongobg?
{
"_id" : ObjectId("592af041affd0cc7e3f35565"),
"name" : "Transport",
"sub_category" : [
{
"autoincrement id":41a6s5d1a6s1d5 <---- here?
"name" : "Cars"
},
......

R

Roman Mirilaczvili, 2017-05-30
@2ord

EAV pattern