No support repository in SDK

TiaLeave a comment

Tried to add constraint layout to my build file for Android. All roads pointed to adding the support repository, however, there was no support repo. Added, instead, maven to my build, changed to implement, and all was well. 

repositories {
    maven {
        url 'https://maven.google.com'
    }
}

Tia’s log – 191119 :: PHP, Flutter

TiaLeave a comment

Working on today

  • PHP code updates for LMS
  • Flutter chore app!
  • Java selenium/jsoup program
  • Client research for their LMS
  • Nanowrimo!

Notes to self

  • Guess who may learn electron….
  • Bearer is mainly a standard in the authoriziation header in Oauth. Still, a standard to send in a token of some sort. HTPasswd would use "Authorization: Basic"
  • MVC models are facades. Fight me.
  • Netmasks can be used for IP address for mysql. For example, ‘192.168.0.0/255.255.255.0’.

Angsts

  • I hate people copying and pasting and not understanding the code. So, when they have to make a change, they have no clue and it takes them even MORE time to figure out what’s going on than if they had learned it and written it themselves.
  • Not a big fan of these big project management things, even with multiple people. Give me a good marked up spreadsheet any day.
  • Need more RAM. (Coincidentally, I typed this as my computer fell to a blue screen)

Passionates

  • Oh, my goodness, yes. Finally found a note app that I can completely dig: Notable . I like one note, but man is it overkill for what I need to do.
  • I love line debuggers. I always hate going back to CF when using OO (CFCs) or Java and not having them proper 😦 .
  • Finally realized I can recreate what some of these larger programs do, but on the scale that we need. As much as I’ll push a good ole’ framework, many are overkill for small shops like mine.

Olio

  • Rememember SourceForge? I mean, it’s still there, but with Git, these young’ens don’t much. Just remembered I have an OLD php script there, circa 2002. Goodness.
  • One of my favorite Twitch steams https://www.twitch.tv/adam13531
  • I love the TODO extension on Visual Studio Code so_much_. I would love something so simple, but highly efficient, on Google Drive, or anywhere. The color coding, shortcuts, and time stamps make it something absolutely necessary for me. This one: Todo+
  • I still love RSS so much. Decided I’d cut back on Reddit (where I’d stay up with tech a lot) and focus more on feeds. That and the fact that I have a slight Reddit addition. Probably the endless scrolling…. What are some great blogs you follow?

Tia’s log – 190531 :: JavaScript

TiaLeave a comment

Notes to self

  • Javascript is seriously pretty freaking awesome these days. I remember when it was all about cursor followings, no right clicks, and horrible password protection. Not too mention, no good for accessibility.

Angsts

  • Coworker told me learning how to use the google recaptcha in a project would take 30 hours. Oh, hun. It’s seriously a drop-in and minimal configure. This just reads as- I don’t want to do it because you suggested it and I want an even easier solution.

Passionates

  • I’m digging the debugger in the Firefox console. I mean, I’ve used it before, but I’m sure no where near what I’m doing now. Such improvement on the old days. Let’s get it.
  • Yep. I’m annoying. I’m the girl who will change all your deprecated CRAP HTML to standards (after ensuring it works and that the user base are using standards compliant devices). Oh, I’ll be spreading some lets, consts, et all ALL up in your JavaScript. I know most of the people I work with are old-heads, heck, I am too. But I see NO ONE wanting gotos. Let’s move forward.

Olio

  • So what’s your daily practice look like? I mean, if you are a programmer, you program. But how do you learn at work all the while working?
Some suggestions:
  • listen to programming podcasts
  • listen to and casually view LiveStream programmers and Youtube tech chats
  • Read a code review on a code review site
  • Follow some good blogs that’ll help you learn more. I recommend really only reading one. Save the rest somewhere like Pocket
  • Do a code exercise — best tip for this, don’t do it in your primary IDE. Do it somewhere that won’t give you all of the boilerplate and hints, but still keeps some niceties like color coding
  • Research a small but complicated topic in your language of choice. The best for this is looking int a specific method, function, or package and learning it inside out
  • Watch a video on coding practices
  • Watch a video that will make you more efficient in your tools
  • Blog, share
Rant

These are little things you can do during breaks at work, and still get everything done. I do want to say, I don’t care too much for all these latest tirades on people working at home and or being passionate about coding. I had someone tell me coding couldn’t be a hobby. This was an artist! You know, someone who constantly blurs the line between profession and hobby. Suffice to say, it can definitely be a hobby. It can also, definitely, just be your job. Do you. Like what you like. Is that too hard for some people? Know yourself. Know what you can take on. Know when to take breaks. Know when you need to shelf something for a few months to come back to it later. Outside of that, the sky is the limit.

Share

All the console functions for JS

Etc

Goooooo Raptors!

I did a thing :: JS arrow function

TiaLeave a comment
Image result for js arrow function meme

My first time purposely, intently, and actually using a JS arrow function, and boy, was it nifty 🙂 .

Don’t know what it is? Basically, stop thing of sending in to a function, start thinking:

I have this thing (probably an item esp. for array functions); I want to send it here and this side will transform it.

Yeah, that’s a little too simplified.

Check it out: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Functions/Arrow_functions .

Mmm… sugar. (Not solely, but for my purpose today, yes.)

Tia’s log – 190529 :: mssql, sql, jQuery, WordPress

TiaLeave a comment

Please, for the love of goodness sake, if you are not the person working on an program/script, don’t assume it will be "easy". Your easy may be someone else’s headache. Also, please don’t query someone on some code that they wrote a million, bazillion years ago and expect an immediate answer. Heck, I barely remember what I did yesterday.

Side note, I’m submitting my first submission for documentation on of my favorite open source projects today. Wish me luck!

Notes to self:

  • JQuery is still pretty good. Don’t @ me.

Angsts:

  • Random SQL triggers are not my friend. WTH. Praise almighty goodness for "DISABLE TRIGGER" (Are you triggered? This is to create test data, no worries.)
  • Still don’t like MySQL stored procedures. 😦
  • I don’t care about writing documentation, but I’m not the best. I’ll mostly link you to resources based on what we are doing that I know will stay maintained. Or, if it is a list of tables/procs – I’ll tell you the prefix or schema. Just, for the love of goodness, don’t expect me to handhold you through eveyrthing or explain every basic concept. If you can’t take the initiative to do a little research, what good is my writing it down in a document going to do? Perhaps for others, but no one else has needed it… because, some of these things are CompSci 101 or even W3Schools level.
  • Meetings still suck and are still draining.
  • Renaming a database in MySQL still sucks. Hoorary, Percona!

Passionates:

  • I love VanillaJS so much. I’m always so happy to use it in my day-to-day although I primarily work on the backend. Hopefully soon I can begin the transition of our large codebases from jQuery to vanilla and Vue. Not sure how well Vue plays with a site that isn’t a SPA, but I suppose I’ll see.
  • One of my greatest joys is digging into someone elses code, figuring out how it works, updating it, and improving it. I’m just that good. (Typically, IRL, it’s more like breaking it, but, hey!, I know where it was brokah. Huzzah for tests.)

Olio:

  • One more note about documentation. I’ve always been one to keep so much in memory, simply because that’s how it was passed to me. I’ve seen the usefulness of documentating not just, or specifically, how things are done but: why, possible issues, and resources. Invaluable. I like one Twitch streamer I watch who puts his documentation in one note. It’s super nice that one. I’d even go as far to say that it is MUCH better than documenting on Google Docs or Evernote. That streamers name? No clue, atm.

Tia’s log – 190430 :: mysql

TiaLeave a comment

Notes to self:

  1. SHOW FULL TABLES WHERE TABLE_TYPE LIKE ‘VIEW’; – shows all views in the current mysql database. Add to that "IN dbname" after TABLES to specify which database. Adding the word FULL gives a new "table_type" column, which gives the type of table including a view or system table. No FULL such as just "SHOW TABLES" will list all in a database.
  2. CONCAT_WS has a seperator vs just CONCAT. Additionally, if anything is NULL in concat YOU ARE SCREWED AND THE WHOLE THING WILL BE NULL (as of today and MySQL folks). Otherwise, _WS allows nulls. They are skipped, in this case.
  3. Group_Concat, which groups values data together in a nice comma seperated string, has a default value of 1024. It can be changed at runitime by setting group_concat_max_len to a valid positive integrer. It is, however, constrained by max_allowed_packet.

Angsts:

  1. Shared hosting is no good. If I can’t create a proper stored procedure or view because you want me to use your web view and restrict those, we are not friends.
  2. MySQL isn’t as friendly for creating pivot tables compared to some of the other RDMS systems. So how do you? You group by a common ID (typically, ID) and then you get the max (probs value) or some other aggregation method of the records you want (probs name/field/etc.). How does this work? Know this: you group by an id, once there, you are pulling in the value that fits your aggregate. In my case, the max entry for that grouped id.
  3. Stored procedures in MySQL are still not one of my favorite things to write.
  4. ARGH jkljouoweur. All the good JSON functions are in MySQL 7+. Guess it is off to let the codebase do it properly.
  5. There is, currently, no "CREATE OR REPLACE PROCEDURE". MariaDB has it, but I’m on MySQL, so, oh well. Drop and recreate is the best way to go. There is an alter procedure, but according to the docs (@see https://dev.mysql.com/doc/refman/5.7/en/alter-procedure.html): "However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE." HECK.

Passionates:

  1. SQL Fiddle is pretty great for sharing SQL.
  2. CREATE OR REPLACE for a SQL view is pretty nice.

Olio:

There is this little thingy to create Pivot tables in MySQL. I guess if you don’t want to write out the sql, this will help? mysqlpivottable

So, you wanna be a programmer…

TiaLeave a comment

Are you really interested in programming? I know folks who want to work as programmers, but don’t like to use Google to search for basic stuff. Your code isn’t working right? Your program won’t start, but you get an error message? Get the hockey sack out of here, either you want me to do your work, or you are fully incompetent. If you can’t search for an answer and work through debugging (aka trial and error), or RTFM, you aren’t ready to be a programmer. Heck, you aren’t ready to use a computer.

So, yeah. I thought I’d start this off with a good ole’ rant. I’m a sweet-lovin’ midwestern gal, so there won’t be a lot of that, but hey, this is my blog out in space, so who cares, really?

What’s going here? Daily notes as a reminder to self, things I love, things I hate, things I find, things for you to code (yep, I sometimes fancy myself a mentor/teacher), and just random thoughts like that above.

Sit back and let’s talk code.