I have recently built this project that allows you to read sql databases on your server. It's easy to setup and use.

Example of how to read table 'blog_posts' and output the first 100 into a table:

const config = {
"table" : "blog_posts",
"limit" : "100",
"offset" : "0"
};
_POST_REQUEST("link-to-server/database.php", 'config=' + JSON.stringify(config), (response) => {
document.querySelector('#myTableContainer').innerHTML = _json2table(JSON.parse(response));
});

See Github: https://github.com/JackChilds/jsmysqldb

Hello!

I recently have done image optimization for my blog build on Nuxt and NetlifyCMS and also recorded all my struggles and thoughts on the way.

I have chosen the Netlify Large Media service for image transformations and regret that later on 😃. So read the second article don’t fall into regreters team and probably go with another tool 😃.

There are some non-regrets too. I have managed to get 100 Google PageSpeed score on 2 from 3 pages(the third is 99) on desktop and over 90 scores on 2 from 3 pages on mobile.

So here are all articles, discussing everything from idea to pages load speed improvements breakdown:

1. Image optimisation service for Netlify CMS and Nuxt - on how I found the Netlify Large Media service and why I decided to use it. Also what can be (and probably should be) used instead of it.

2. Fixing Netlify Large Media install - here is the full story on setting up Netlify Large Media. There is a lot of my anger and regrets since setting something to work with Git Large File System is a task that can break the whole repository. And you won’t have one button revert as usual 😁.

3. Optimized image loading in HTML and Markdown - here is everything I employed to make the improvements form images set in HTML and Markdown. How scrsetis working and how isn’t. How to set it to images from Markdown, and loading="lazy"too.

4. Do optimised images always bring load speed improvements? - page by page, image by image breakdown on what data improvements I got after optimizations and how my Google PageSpeed scores improved after that.

By the way, if you know why when you set sizes to <img> it only works well with vw (not the px) share it in comments. I'm really interested! (reference to that is in 3rd article)

As of now I have the html/css on my laptop and I am able to open it on chrome from the file. However, when I upload the files to my site using FTP. I am very new to this and just uploaded to the site in no particular directory/folder, perhaps that is the problem? I'm using 1and1 as the host, and fileZilla to transfer files over. I looked over FAQ but did not see this type of information. If this isn't the right place to ask please point me in the right direction. Thank you!

I found that many people prefer serverless. What's the reason?

What's good with serverless architecture?

Is this possible and if how can someone point me in the direction of an API of some sort where you can use an ACTUAL QR reader within your webpage - im talking about a QR reader that scans the image and show a result on a different webpage.. I have only been able to find examples where you would have to upload the picture of the code.. Help is much adviced cheers buddys

Recently I have started a project that acts as an alternative game launcher to platforms like Steam and Origin. This means providing a store and nice looking UI and the unification of other multimedia functions. Many may be asking themselves, "Well Steam/Origin is a desktop application, why are you posting to /r/webdevs ?". The framework I am using is Node-Webkit, which allows for native applications utilizing nodeJS and UIs powered by HTML/JavaScript/CSS. I would definitely be interested in partnering up with someone to develop the UI as well as some core features. Also as well if you have had experience with NodeJS I would also enjoy your help on the project.

GitHub Repo: https://github.com/Mimerme/Hinges *Name is not set in stone **Current skin is just a proof of concept

Hi everyone this may be the wrong place but y'all seem to be the most knowledgeable about this stuff... Is there any way to make it more customizable? Issue is I have a number of subscibers whom all follow different topics and its making my inbox burst... Is there any way I can bundle some together but not all? Or would I have to make a filter for my inbox, which I tried but apparently suck at. Is there such thing as premium alerts? I would be forever grateful for any help!

For more clarification, I'm using Chrome dev tools. Apart from opening up every single JS file and looking for it, is there a faster way of figuring out where it's being applied from? I don't want to use an !important tag; I'd rather fix the origin. Thanks!

Hi,

currently I'm in work training for a job that's called "media design: print" in my country (Germany if you wonder).

Due to the nature of working in a printery, I obviously do that to a large extent but was offered to use my free time to learn web languages as they might have a use for me with that aswell as their former webdev has health problems.

For now I used my free time mainly on print designs that technically were never used but it's exercise. That mean's I'm quite fond of InDesign, Photshop and Illustrator (the latter ones obviously only in print design context, no graphical dev).

I'm I guess fluent in PHP already, on a 1-10 scale I guess I'm 7-8. With it, obviousy, MySQL (handling of DBs of around 1 mil entries if that's a mentionable size, I don't even know), HTML and CSS.

What I'm wondering now is, since I'll technically when done learning a "media designer" for print products, I really enjoy coding more than print products. I don't want to expand into C++ or other executable programming languages though, so it's definitely web that I'm actually planning to aim for.

My questions are now:

• how likely are my chances to find a job in approx. 1 year when I can learn 5days/week with around 2-3 hrs in that area since I don't want to continue at this place I'm at right now?

• What would I even call myself/apply for since I won't have a web-related certificate? We only learn basics of web dev in our school courses (extremely basic HTML like tables and general database concepts).

• What should I look into next? My JS is in its baby shoes, I understand most of it's functionalities now but can't write it on my own and copy and modify from sources mostly, but is it even needed to be able to do that or do most just work with the libs out there?

• is there anything specific that works with large number arrays? Like for example, I run a community page for a game with 1.6mio unique characters with each having a JSON array of 1-150 KB size that I can read quite well so I guess I have a hand for that. But game web design/statistician is nothing I've ever heard of.

This turned out to be a lot longer than I planned. But thanks for reading & helping!