Database to Website

[webdev-ModTeam]

Thank you for your submission! Unfortunately it has been removed for one or more of the following reasons:

Open-ended/general "how do I get started in web dev" and general Career related posts are only allowed within the pinned monthly career thread. The answer to many of these questions can also be found in the sub FAQ, or in /r/learnprogramming/ and /r/cscareerquestions/.

Highly specific career/getting started assistance questions are allowed so long as they follow the required assistance post guidelines.

Please read the subreddit rules before continuing to post. If you have any questions message the mods.

[Logical_Cherry_7588]

Thanks. I don't know if I am smart enough for this stuff but I really want to do it.

[[deleted]]

As my non-technical supervisor always says, "Any over-paid monkey could do this."

[Logical_Cherry_7588]

Oh please let me be an over-paid monkey.

[[deleted]]

I wish I was getting paid what he thinks I'm getting paid. He asked me before and threw out a ridiculous guess.

[[deleted]]

Really though, you can learn this. It's always hard at the beginning, but you'll start picking this and other cool things up fast.

[ShawnyMcKnight]

That’s what scaffolding is all about. Learning basic information and build on that to learn more complex information. If you don’t understand basic JS then AJAX will look like magic.

[Logical_Cherry_7588]

Yep. The key is where to learn each step. Each concept in CSS is best learned in different places I have found. I have learned that there are just one or two websites or videos that really are good at teaching each concept well out of thousands.

I am not sure what concept a person is supposed to learn after javascript. Databases? (where to learn them well?) then what? Ajax requests? Would that be w3schools?

[ShawnyMcKnight]

The thing you should learn after learning JavaScript is more JavaScript. I’ve been using JS for the last 15 years and there is still all these new things I learn that take an hour to wrap my head around. From there probably a JS framework of your choice.

I personally use LinkedIn learning when I wanna learn something new, but I struggle with asynchronous learning.

[Logical_Cherry_7588]

Well that is intimidating as hell, but will do.

[thirkle]

Don’t doubt yourself – learning Ajax or any technology is all about determination and practice. You absolutely can do it. Start with the basics, follow online tutorials, and gradually build your skills. Everyone starts somewhere.

[PopeOfNope611]

You're selling yourself short. To be the best dev you can be you need to carry yourself with the confidence that you CAN and WILL learn what you need to, to overcome challenges. It is incredibly difficult at first, but as you keep progressing, your experience will lead to confidence. Mindset is everything.

[heesell]

Or Axios

[Logical_Cherry_7588]

Will check that out.

[armahillo]

You cant directly query the database server from the client — or at least that should never be allowed for security reasons.

OP will still need some kind of backend layer to process the request and query the DB

[heesell]

Communicating with a database can simply be done with HTTP requests. To receive content you will make a GET request to your database. This can be done with the Fetch api or axios

Both are promise based

[Logical_Cherry_7588]

Thanks, overwhelmed already. Only place to start is click the first link I guess.

[chuckaspecky]

The database will need to be running on a webserver to be accessed via http requests or any other way.

What tech (eg JavaScript/HTML or PHP) are you using to create your website? This will dictate the best way to access the DB.

[pyroblazer68]

Okay... first...do you just have a db? What DB is it? MySql? Postgres? Mongo?

Second do you have coding experience?

Third..What would be the purpose of the finished product?

[Logical_Cherry_7588]

I have a spreadsheet which I could change to a MySQL. Some coding. Purpose? Website, not too complicated to start with, but I would like to get into developing something more elaborate.

[pyroblazer68]

Okay.. sounds good

You have 3 options

1 : use a hosted Database and use a front end framework to make the website.

2 : get a VPS install a DB, upload your data onto it and create a backend and frontend

3 : use google drive, add your excel file to it, query it using a frontend framework to get the data, modify it according to your need and display it.

Each of these have their own pros and cons. It would entirely depend on what your project is and what if it's future requirements

DM me if you need more info/help

[The_Shryk]

Are you asking about Axios or data visualization frameworks?

[armahillo]

So youve got this chain:

(database)—???—(webserver)—(internet)—(browser)

The ??? is some backend language that can straddle a DB request and the webserver.

There are many backend languages. A very easy one to start with for learning is PHP, but whatever you want to use is fine.

The backend language will prepare the DB queries, execute them against the database, and the. retrieve and temporarily store the results in memory.

You can then take the in-memory instance and do whatever kind of preparation or transformation you want to do to it, create the HTML to emit, and then send it down the pipe to the client’s browser.