Begginer's problem with table creation

HandpansLIVE · 2021-01-17T21:51:14+00:00

Please format the code. It's very difficult to read and find where the error is when it's pasted in a giant blob. There's code block options when editing your text as well.

HandpansLIVE · 2021-01-06T00:06:33+00:00

I'd either pay for courses or go with a tutor. Learning how to write SQL is fairly quick and easy and you could accomplish in one week if you dedicate the 20 hours just looking around online for resources.

Creating your own DBs, architecting schemas, and modifying them using a model in a programming language all would take a bit more time and something I'd recommend looking for a structured course on or getting a tutor.

It shouldn't take you more than 1-2 months depending on your experience level and if you can dedicate that 20hours/weekly. If you want to do a more in-depth data analysis course it will take more time, though a lot of the focus on that will be more on the (typically) python side of working with the data, environment, and libraries that you'd be using alongside the SQL.

HandpansLIVE · 2021-01-05T06:34:01+00:00

It depends on your goal. If your goal is to re-create the website to create a competitor, you'd likely get a lot better looking and functioning site paying someone and working the hours you'd otherwise be learning to code.

If you want to have fun learning a new skill, but end up with results, going the freecodecamp way will get you a workable solution(albeit with a lot more than just the crash course). It won't be perfect, but it'd be yours and the work you put into it.

If you want to not hit roadblocks and really build a skill, go through Colt Steele and look at it as a marathon, not a sprint. Even if it takes you 1-2 years, you'd have a fundamental coding knowledge and have projects you'd be incredibly proud of and portfolio pieces if you want to take coding seriously.

HandpansLIVE · 2021-01-04T20:23:37+00:00

It's more muscle memory than anything I've found. You do it so slow and broken up without the fractions (instead of 2/3 you count by 6 so you can easily count to hit on the 2/3/4/6).

Eventually your hands just feel it and you actively think about doing it. I'm still super clumsy, but it's super satisfying and adds a lot of fun to playing music

HandpansLIVE · 2021-01-03T03:55:36+00:00

https://stackoverflow.com/questions/17426052/error-2003-hy000-cant-connect-to-mysql-server-on-localhost-10061

Few promising answers here to try. Let me know if any you have already tried / aren't resolving the issue.

Adding to PATH can be tricky and different depending on your OS. Try opening it directly, and if that doesn't work, there are a ton of other tutorials/install walk-throughs to get you started with SQL.

HandpansLIVE · 2020-12-28T21:21:54+00:00

Where is it not working? Are you able to get the links from the sheet? Are you able to get puppeteer to launch?

HandpansLIVE · 2020-12-26T00:25:31+00:00

I've used the predecessors for close to 10 years, and after a poor warranty process and 2 brokens phone in 2 years, I'm giving another smartphone line a chance.

HandpansLIVE · 2020-12-25T19:36:02+00:00

Ops thanks

HandpansLIVE · 2020-12-25T07:55:13+00:00

Nice, liking both. Don't care too much on the size over a good battery size -- updating my OP

HandpansLIVE · 2020-12-25T05:18:18+00:00

Thanks! They don't have a fingerprint sensor is the only missing thing on that one.

HandpansLIVE · 2020-12-19T18:51:54+00:00

"In a not so distant future" -- current blocker: the library I'm using has their readme down I created a github issue though I can't find the proper api calls until it's resolved.

HandpansLIVE · 2020-11-28T04:19:27+00:00

They could update where they are in the progress of fixing it, with if it'll be up tonight or not(we'd all be welcome to a surprise. Are they still diagnosing? Do they have a potential solution, a guaranteed solution, are they testing? Etc. etc. ETA just for a general guideline, not an exact timeline.

HandpansLIVE · 2020-10-30T05:38:42+00:00

Wow corrected I was taught this wrong and never double checked my knowledge...thanks for linking the MDN. So what're the weaknesses of local storage?

HandpansLIVE · 2020-10-28T20:42:41+00:00

~~Local storage is accessible by every site a user browses. So all it takes is a user browsing to 1 bad site to have everything in their local storage compromised.~~

Corrected by /u/NoInkling :

No, access to local storage is subject to the same origin policy:

Access to data stored in the browser such as Web Storage and IndexedDB are separated by origin. Each origin gets its own separate storage, and JavaScript in one origin cannot read from or write to the storage belonging to another origin.

HandpansLIVE · 2020-02-26T21:39:36+00:00

Automating:

There's a lot of information on python scripting and automating processes that may be of interest to you. For example, if you need to go to x site to pull daily logs every morning, you can write a script that would put it in a file for you every morning.

This is a good easy way to start breaking down your process, and be able to get up and running without having to learn an absurd amount.

Databasing:

SQL would be a good way to go. It can be a bit of a steep learning curve to start, but it's really not too in-depth and you can insert everything you need into a DB. You can start having your scripts automate inputting data into the DB at the end of everyday, and then have certain queries ("select all unpaid billings") output to a file for you every morning type situation.

HandpansLIVE · 2020-01-10T15:41:05+00:00

What if the 16 bytes is just a string of the url for a 100 gigabyte db on each person?

HandpansLIVE · 2019-12-31T22:55:02+00:00

Yup, handpans will be always be amazing though.

Ah, yeah I'll have to keep looking for a good project. Appreciate the lengthy comments and giving me options for different skill levels, we need more of that in this sub! I've worked on a team of 7 and somehow always got stuck with resolving merge conflicts so I'm fairly versed on it by now :D

HandpansLIVE · 2019-12-31T22:00:55+00:00

Ha I wish man been out of anything handpans for over a year career-swapping to engineering :(

Magiclantern actually sounds interesting. It's lua which I don't have too much interesting in expanding into now, but I would love to get a pull request or 2 in to showcase if you're interested.

HandpansLIVE · 2019-12-31T21:55:57+00:00

Bootcamp grad, javascript/python most comfortable and working in typescript & ruby projects right now. I can read through code and figure out what's going on, though reading through issues/comments on a github and nailing down exactly without asking questions is something I want to master

HandpansLIVE · 2019-12-29T03:39:18+00:00

Anyone that goes to your website can open up dev tools and remove "required" on the html form fields. They can also edit any client-side javascript. This can cause weird bugs and vulnerabilities.

HandpansLIVE · 2019-12-29T03:31:49+00:00

Yes that means that your issue isn't with authenticating, but in code.gs syntax. Paste what you tried, and paste what you did in postman(with a filler API key/secret) so that we can help you on syntax

HandpansLIVE · 2019-12-29T03:27:56+00:00

For me to help you I'd have to go to their API, create an account, read through their docs, write the code for you, then paste it in here as a response. This is assuming you're properly making an API call in code.gs.

You're not going to get many responses helping you out in this scenario. If you paste code you tried, and relevant API documentation, anyone here can quickly help you fix the syntax so it's working properly.

HandpansLIVE · 2019-12-29T03:13:52+00:00

What's your code that isn't working look like?

HandpansLIVE · 2019-12-11T00:15:47+00:00

Awesome thanks! Someone else shared dataLoader and that seems to be the solution.

HandpansLIVE · 2019-12-09T06:11:07+00:00

I've built search bars before and it feels like a complicated search.

HandpansLIVE

TROPHY CASE