__app_dev__

Yeah I haven't used pl/pgsql but it reminds me of Oracle's pl/sql which is very powerful.

At first the Oracle version felt clunky to me too but then after taking time to learn it I also found moving complex app logic to SQL allowed me to make complex app changes much quicker. I have use that method of development now for years in a variety of apps and databases and it works great.

Thanks! Once I used dbeaver for SQL Server (can't remember why) but I can try it again in the future next time I use Postgres.

I think for Enterprise SQL Server is increasing if anything (due in part because so many Companies run windows Servers internally) and developers can install it for free.

I do like the power of PL/pgSQL although I've never worked with it in detail. I reminds me of the power of Oracle's syntax without the huge cost that only large companies can afford.

That's for the tip!

I've used JetBrains for Development before and consider their quality exception so next time I use PostgresSQL I'll give it a try.

I've also used Navicat for SQLite and like it so I'll probably try that one as well.

Thanks for the info!

I've been using Navicat for SQLite and like it. If I ever get a PostgresSQL job I'll try it there since it works well for SQLite.

At my current job we are on IBM AS/400 for ERP (legacy and replacing it would be very high risk as it would change the business drastically so that won't happy any time soon).

For all other stuff we are using SQL Server and several of our key 3rd party vendors only use SQL Server. I think the fact too that some many companies run Microsoft Network and Servers that it naturally lends toward the network effect as you mention. Plus while it's expensive it's 10x cheaper than Oracle in many cases.

> all of its competitors are essentially obsolete

For most companies I've worked at I've used either SQL Server or Oracle and from what I've seen when looking at job posts recently the demand is only increasing. Although I live in Los Angeles and not Silicon Valley.

Additionally Facebook and other large tech companies still use MySQL and outside of silicon valley many large companies still run IBM databases.

I don't see the other major databases being obsolete at all.

I've used PostgresSQL before for learning (~3 years ago) but didn't really like the web based UI compared to SQL Server or Oracle query tools.

Does anyone have recommended PostgresSQL query interfaces?

Also, many cities put Homeless on a one-way bus to San Francisco and other "homeless friendly" cities.

I'm 42 and I recall Florida doing this over 20 years ago when I was in High School.

https://www.theguardian.com/us-news/ng-interactive/2017/dec/...

For many years I lived in Beverly Hills (near Los Angeles). They have very few homeless so it's nice but the rest of LA (Los Angeles) is a disaster right now.

It's not just cities with Good Weather though because Seattle has one of the worst homeless problems. Although I don't have any stats it feels like it's mostly just a West Coast problem as I never hear about this from the middle of America or large East Coast Cities.

I would prefer a take home assignment to the typical leetcode questions or a review of my work and code samples.

Interestingly I spoke with a former Microsoft Product Manager earlier this year and he told me "the most senior engineers give the worst interviews because you have to use parts of your brain that you haven't used in 20 years".

I live in Los Angeles and years ago (and for most companies where I work) algo interviews are not a thing but this year I've been getting contacted non-stop by recruiters including several FAANG so I've been cramming leetcode and it's not fun.

I've come to realize that by cramming leetcode I'm also missing out on important topics such as security, real-world performance, and other things that I used to actively study.

But at the price Silicon Valley companies pay it can be worth it I guess.

I agree there is a shit-ton of stuff to set up but based on the recent Pipeline and other Hacks where the Companies had to pay millions I would expect more companies to take stuff like this seriously.

Thanks! Yeah, articles like this I would have studies in greater detail in the past but this year I realize In need to improve my leetcode/algo times so long term I'll keep focused on security and important topics. But in the meantime ... time to zig-zag a binary tree :(

There was a famous case about 6 years ago where Google didn't hire the author of Homebrew because he couldn't whiteboard a leetcode type question. He posted to Twitter, then it was discussed heavily on tech sites:

https://www.reddit.com/r/programming/comments/39d0u1/google_...

In my opinion the problem has gotten worse. I spoke with a former Microsoft Product Manager early this year and he mentioned "Highly experienced engineers give the worst interviews" .. based on the current environment. He mentioned it's because the questions that come up are stuff people learned 20 years ago and never used in real-life.

I was invited by several FAANG companies this year to interview and did one interview (and turned down others) but had to cram for 2 months doing leetcode.

I realize it's a game but have mixed feelings. I think the interviews are bad if it's the only option but part of me knows the interview process is so bad it will likely discourage people from being Software Engineers and keep salaries high for many more years.

I used to study and focus on security a lot more and keep up with trends. After several interviews this year I realize a lot of jobs prioritize leetcode over everything else. It's pretty annoying and makes me wonder if the focus for tech works is leetcode above all else then no wonder so many companies have insecure apps and servers.

I think to the fact that other "engineering" industries do have licenses. There is no way legally they could get away with these types of interviews.

I used to be a software developer and an architectural firm (that designs buildings). The architects plus engineers had to go through 5 years of college, do years of on job training, all before they can be licensed.

I felt kind of bad for them though because I made more then most of them before I was 21.

The interviews are crazy though. The last big company I worked at had a "probation" period. For Sr Software Engineers we would only do a single 1 hour interview. But if they did not do well in the first 90 days we could fire them.

Seems much better than telling people to study leetcode hours per day for 2 months prior to an interview.

Totally agree! I've been getting hit up by FAANG recruiters (and other companies) non-stop this year.

I live in Los Angeles where companies never did this type of interview when I last got a new job (4+ years ago) so I had to grind LeetCode for several months then didn't get the job I studied for even though I got all questions right (I was a little slow on some of them). I kind of resent it because I know my time can be much better spent (keeping up on security topics for example).

The process is so bad it makes me hope to be no longer doing software development as a employee sooner than later.

Good one, I get contacted by Amazon several times a week on LinkedIn to apply.

For my LinkedIn I listed minimum requirements and it saves me 100+ inquiries per week but I still get a ton of irrelevant jobs.

I worked at Nielsen (TV Ratings) 3-4 years ago and we used it all the time and not for tech. At the time it was used by all he major Entertainment Studios in Los Angeles as well. Any type of office role it: Marketing, Mathematician, Software and Data Roles, ...

Never used it at small companies so it seems mostly used at larger companies or relatively new.

In CA (at least Los Angeles) there are some tax laws in place that allow a home owner to make more in tax breaks by not renting a house or building vs renting it out.

I don’t know the details as I'm a renter but from speaking with a few Realtors they mentioned the companies the worked at did this.

I created a Fractal Demo using Houdini that is featured on houdini.how:

https://github.com/ConradSollitt/css-houdini-fractals

It's similar to rendering with canvas. houdini.how is a Chrome Labs Site from Google and allows authors to submit demos. I would recommend creating a demo on it for any developer that wants to try Houdini.

https://github.com/GoogleChromeLabs/houdini.how

It comes with a simple API and if a fully custom version is needed the source code for the Component exists in a single file so it can be easily copied and modified.

Here is the source:

https://github.com/dataformsjs/dataformsjs/blob/master/js/re...

This is a Single Page App (SPA) using a Web Component Library I created. It uses data from a Geographic Database to countries, regions, cities, in the World.

If you’re not familiar with Web Components here is a good overview article from Mozilla on how to use them:

https://developer.mozilla.org/en-US/docs/Web/Web_Components

Basically it allows for creating custom HTML elements from JavaScript. In this case I developed components that allow for viewing of data from JSON web services and binding to other components on screen.

Here is the GitHub Source:

https://github.com/dataformsjs/dataformsjs/blob/master/examp...

For comparison the main page has links to React, Vue and other versions of the same app as I developed similar React Components and standard JavaScript.

https://www.dataformsjs.com/

There is also a same version of the app written with Handlebars:

https://dataformsjs.com/examples/entry-form-demo-hbs.htm

Basically I wrote a JavaScript SPA Framework that allows Vue, Handlebars, and some other Templating languages to be used in a low code manner for working with web services.

The only JS needed for that app is used with the Auth and the library works with generic web services and GraphQL so it’s easy and quick to modify.

Thanks, yep not to scale and in fact I just made up the land on the planet as it ended up looking better when I kept it simple.

From the main page you can also see the same demo using Redux, Flux, and basic React Hooks.

In case you haven't heard of Recoil it was published from Facebook Experimental about 5 days ago.

https://recoiljs.org/

https://github.com/facebookexperimental/Recoil

This demo hosts all files from a CDN so you can view JSX code directly in the browser (a JSX browser-based compiler is used).

It works by embedding a <style> attribute with CSS animations within the SVG.

The same animation exists on the main site however it’s embedded in the page for wider browser support.

For the GitHub readme I combined the two SVG images and made some adjustments to use [transform-origin] instead of [margin].

It works with most modern browsers but not with IE, while the main site has broader browser support because everything is embedded on the page rather than in the SVG. Additionally the animation works better on a desktop than on my phone (iPhone with latest iOS).

Client JavaScript Code (React): https://github.com/dataformsjs/dataformsjs/blob/master/examp...

Client JavaScript Code (Vue and Handlebars): There are 3 different versions of the same demo to show the app being built with different client side tech. https://github.com/dataformsjs/dataformsjs/blob/master/examp...

Server Source Code: https://github.com/dataformsjs/website/blob/master/app/app.p...

Server Setup (Ubuntu -> nginx -> Gunicorn -> flask -> [keras, tensorflow, sklearn]): https://github.com/dataformsjs/website/blob/master/docs/Pyth...

Ha - good timing! I've been using VBA today and yesterday actually!

Often only a few times a year I use it now but when I do it I feel productive.

In case your wondering I has a previous Excel VBA Macro that I wrote for updating a SQL Server Database based on data in Excel. The macro first has to run checks against data in an IBM AS/400 Database.

I ended up having to pull out the macro to do a bulk update in an ERP. It was faster to do this then re-write in an modern language (especially since I work with the data in Excel first).

That's correct. In most cases React is used with client side tools `webpack`, `create-react-app` etc and all of these depend on Babel.

There is a Babel Standalone file that works when used directly on a page but it's huge 1.5 MB of JS so and it takes many seconds to process.

The `jsxLoader.js` file I created uses Babel Standalone for old browsers (IE 11) and then for modern browsers it transforms JSX to JS very quickly without the need for Babel.

Do you build React Apps?

If so what are you using other than Babel?

Great Question. Looks like I need to make the document clearer on why.

All Demos and Templates use the React CDN links you listed.

The reason this file exists is so that JSX Code can be used in a browser without Babel. Babel Standalone can be used on pages but it is huge and takes a lot of memory and a few extra seconds to display the page. The [jsxLoader.js] file allows JSX to be used almost instantly.

Here is a Hello World Demo:

https://www.dataformsjs.com/examples/hello-world/en/react.ht...

If you view with any modern browser it will use `jsxLoader.js` as the compiler and if you use IE 11 or other old browsers it will download and use Polyfills with Babel Standalone.

In case you see this and are wondering why?

Basically Unit Tested and Demos pages needed a Web Server and originally I was using PHP. But of course I didn’t want to publish a npm/js project that needs PHP.

I could have simply used express but at the time was developing the project on multiple computers so having a zero dependency express-like web server allowed the project to remain small and very quick to copy.