matthewpomar
Name: matthewpomar
Score: n/a
Last Seen: 327 days, 14 hours, 16 minutes ago
Member Since: 8 December, 2021
Role:
Moderator
DeveloperSites
atom rss
2
likes
spam Like Dislike

Unleashing the Power of Project Loom: A Comprehensive Guide to the New Java Concurrency Model

posted by matthewpomarmatthewpomar 448 days, 12 hours, 48 minutes ago
Thursday, January 5, 2023 12:20:48 PM GMT
Project Loom is a new Java concurrency model that aims to improve the scalability and performance of Java applications by introducing lightweight threads called fibers. These fibers are created using continuations, which are a way to capture the state of a method and its call stack, allowing the method to be resumed at a later point in time.One of the main benefits of fibers is that they are much lighter than traditional threads and can be created and scheduled more efficiently by the JVM. This allows ap... (more)
category: Java | clicked: 3 | comment | | source: www.infoworld.com
1
likes
spam Like Dislike

10 Surprising Java Tips and Tricks to Boost Your Coding Skills

published 442 days, 12 hours, 6 minutes ago posted by matthewpomarmatthewpomar 450 days, 3 hours, 46 minutes ago
Wednesday, January 11, 2023 1:02:37 PM GMT Tuesday, January 3, 2023 9:23:02 PM GMT
This blog post provides tips and tricks for Java programming that can help improve coding skills. The first tip discussed is the use of the ternary operator, which is a concise way to write a simple if-else statement. The ternary operator takes the form "test ? true : false", and can be used to assign a value to a variable based on a boolean expression. The use of the ternary operator can help make code more readable and concise, especially when dealing with nested if-else statements. The second tip is ... (more)
category: Java | clicked: 0 | comment | | source: medium.com
tags: Java, Tips
1
likes
spam Like Dislike

MySQL fails to start and no errors in the log? Check out this possible reason!

posted by matthewpomarmatthewpomar 714 days, 12 hours, 40 minutes ago
Thursday, April 14, 2022 12:28:33 PM GMT
Some time ago, I was building a new MySQL DB server (5.7.25) and like all DBAs, I have a template of my.cnf that I use for the new instances after changing a few variables based on the instance resources, replication … etc. I had MySQL installed but I struggled on having the service started! (more)
category: MySQL | clicked: 1 | comment | | source: mysqlstepbystep.com
1
likes
spam Like Dislike

Follow.it Is The Best FREE Alternative To Google's Feedburner

published 799 days, 9 hours, 30 minutes ago posted by matthewpomarmatthewpomar 808 days, 10 hours, 58 minutes ago
Wednesday, January 19, 2022 3:38:45 PM GMT Monday, January 10, 2022 2:10:24 PM GMT
If you have a WordPress website, blog, or even a website running on a another platform, the de-facto choice for publishing your RSS feeds was Google's Feedburner for the longest time. However, Google disabled Feedburner email subscriptions feature in July 2021, leaving many website publishers in search of something to take it's place. Features (more)
category: WordPress | clicked: 2 | comment | | source: follow.it
1
likes
spam Like Dislike

Become a Salesforce Developer or Admin at MyTutorialRack

published 820 days, 4 hours, 55 minutes ago posted by matthewpomarmatthewpomar 820 days, 12 hours, 3 minutes ago
Wednesday, December 29, 2021 8:14:08 PM GMT Wednesday, December 29, 2021 1:06:11 PM GMT
So you want to become a Salesforce developer? Good choice! Salesforce developers are in high demand and companies are paying top dollar for highly qualified and experienced Salesforce developers and admins. Salesforce is prolific in companies around the world. It is hard to find a company these days that is not using Salesforce, or is planning to move to Salesforce. Because of this, "Salesforce Developer" is one of the hottest job roles on the market today. Salesforce is a fun and rewarding development... (more)
category: Salesforce | clicked: 3 | 1 comment | | source: www.mytutorialrack.com
tags: Certification, Salesforce
2
likes
spam Like Dislike

Apex Programming Tutorial for Beginners : Data Types, Variables and Constants

published 820 days, 4 hours, 55 minutes ago posted by matthewpomarmatthewpomar 827 days, 11 hours, 14 minutes ago
Wednesday, December 29, 2021 8:14:08 PM GMT Wednesday, December 22, 2021 1:54:45 PM GMT
In this video presentation, Deepika Khanna teaches you how to program in Salesforce using Apex, the Salesforce back-end programming languages, by introducing you to the various Apex Data Types, Variables, and Constants. (more)
category: Salesforce | clicked: 1 | comment | | source: www.youtube.com
tags: Apex, Video
1
likes
spam Like Dislike

Salesforce Administrator Certification Course / Training

published 820 days, 4 hours, 55 minutes ago posted by matthewpomarmatthewpomar 827 days, 11 hours, 17 minutes ago
Wednesday, December 29, 2021 8:14:08 PM GMT Wednesday, December 22, 2021 1:51:45 PM GMT
Are you preparing for your Salesforce Administrator Certification? Some folks like to go at it alone but others like a more structured approached to prepare for the Salesforce(201) Admin Certification exam. In her video presentation, Deepika Khanna guides you through the various topics you will need to know and understand to get a passing score. (more)
category: Salesforce | clicked: 3 | comment | | source: courses.mytutorialrack.com
tags: Admin, Certification
1
likes
spam Like Dislike

When and When Not To Use NOLOCK

published 820 days, 11 hours, 51 minutes ago posted by matthewpomarmatthewpomar 830 days, 10 hours, 2 minutes ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 3:06:48 PM GMT
To NOLOCK or Not to NOLOCK... That is the question. Lots of developers who don't fully understand the requirements of their application or how NOLOCK works will indiscriminately add NOLOCK to all of the SQL queries. But doing so isn't always the best decision. Brent Ozar describes some times when it is beneficial to use NOLOCK and times where it isn't the right choice. (more)
category: SQL Server | clicked: 1 | comment | | source: www.brentozar.com
tags: MS SQL, Performance
1
likes
spam Like Dislike

Good Reasons Not To Use SQL Server To Send Emails

published 820 days, 11 hours, 51 minutes ago posted by matthewpomarmatthewpomar 830 days, 10 hours, 9 minutes ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 2:59:45 PM GMT
When all you have is a hammer, everything looks like a nail. Over the years, I have seen my fair share of complex SQL Server applications, where loads of business logic exist in stored procedures and cursors churn through thousands of records handling complex business rules and sending out emails. But there are some really good reasons not to send emails from SQL Server. In his blog, Brent Ozar describes some of these reasons. (more)
category: SQL Server | clicked: 3 | comment | | source: www.brentozar.com
tags: Email, MS SQL
1
likes
spam Like Dislike

Want to get a job as a programmer? Learn these high demand languages.

published 827 days, 9 hours, 49 minutes ago posted by matthewpomarmatthewpomar 832 days, 10 hours, 23 minutes ago
Wednesday, December 22, 2021 3:20:14 PM GMT Friday, December 17, 2021 2:46:01 PM GMT
Are you wanting a new career as programmer and don't know where to start? There are so many choices of specialization in the programming world that is can be incredibly overwhelming to decide what programming languages to learn and even harder to know which ones are in demand. The good news is, most programming language concepts are transferable, so even if you decide to learn, let's say PHP today, it will be far easier for you to pickup another language, such as JSP, as many of the concepts are transfe... (more)
category: PHP | clicked: 5 | comment | | source: www.youtube.com
tags: JavaScript, PHP, Python, Video
1
likes
spam Like Dislike

12+ Things You MUST DO Before Changing WordPress Themes

published 827 days, 9 hours, 49 minutes ago posted by matthewpomarmatthewpomar 835 days, 4 hours, 32 minutes ago
Wednesday, December 22, 2021 3:20:14 PM GMT Tuesday, December 14, 2021 8:36:37 PM GMT
Are you wondering what you should do before you change WordPress themes? When switching your WordPress theme, there are few very important steps that you must take to ensure the process is smooth, and you don’t lose any important data. In this WordPress checklist, we’ll share the top things you must do before you change WordPress themes. (more)
category: WordPress | clicked: 4 | comment | | source: www.wpbeginner.com
tags: Theme
1
likes
spam Like Dislike

How to Add Product Tags, Attributes, and Categories to WooCommerce

published 827 days, 9 hours, 49 minutes ago posted by matthewpomarmatthewpomar 835 days, 4 hours, 35 minutes ago
Wednesday, December 22, 2021 3:20:14 PM GMT Tuesday, December 14, 2021 8:33:52 PM GMT
Do you want to learn how to add tags, attributes, and categories to your WooCommerce products? By optimizing your WooCommerce product listings, you can help your visitors find what they’re looking for and get more traffic from search engines and social media. In this article, we’ll show you how to add product tags, attributes, categories, and more in WooCommerce, step by step. (more)
category: WordPress | clicked: 1 | comment | | source: www.wpbeginner.com
tags: WooCommerce
1
likes
spam Like Dislike

The Many Faces of DISTINCT in PostgreSQL

published 830 days, 8 hours, 25 minutes ago posted by matthewpomarmatthewpomar 839 days, 10 hours, 51 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 2:18:07 PM GMT
I started my programming career as an Oracle DBA. It took a few years but eventually I got fed up with the corporate world and I went about doing my own thing. After I gotten over not having proper partitions and MERGE statement, I found some nice unique features in PostgreSQL. Oddly enough, a lot of them contained the word DISTINCT. (more)
category: PostgreSQL | clicked: 1 | comment | | source: hakibenita.com
tags: SQL
1
likes
spam Like Dislike

9 Django Tips for Working with Databases

published 830 days, 8 hours, 25 minutes ago posted by matthewpomarmatthewpomar 839 days, 10 hours, 54 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 2:14:17 PM GMT
ORMs offer great utility for developers but abstracting access to the database has its costs. Developers who are willing to poke around the database and change some defaults often find that great improvements can be made. (more)
category: Django | clicked: 1 | comment | | source: hakibenita.com
tags: ORM, Performance, PostgreSQL, SQL
1
likes
spam Like Dislike

Be Careful With CTE in PostgreSQL

published 830 days, 8 hours, 25 minutes ago posted by matthewpomarmatthewpomar 839 days, 11 hours, 36 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:32:43 PM GMT
PostgreSQL, SQL, PerformanceHow to avoid common pitfalls with common table expressions in PostgreSQL Common table expressions (CTE), also known as the WITH clause, are a very useful feature. They help break down big queries into smaller pieces which makes it easier to read and understand. PostgreSQL Version This article is intended for PostgreSQL versions 11 and prior. Starting at version 12, PostgreSQL changed the way it treats CTE to prevent the issues described in this article.Wha... (more)
category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com
tags: Performance, SQL
1
likes
spam Like Dislike

How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage

published 830 days, 8 hours, 25 minutes ago posted by matthewpomarmatthewpomar 839 days, 11 hours, 39 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:29:44 PM GMT
A while back we started getting alerts in the middle of the night on low disk space. A quick investigation led us to one of our ETL tasks. Every night the task was fired to eliminate duplicate dumps, and free up some space. This is a short story about how we found our silver bullet and solved the issue without adding a single byte of storage. (more)
category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com
tags: Performance, SQL
1
likes
spam Like Dislike

How to Create an Index in Django Without Downtime

published 830 days, 8 hours, 25 minutes ago posted by matthewpomarmatthewpomar 839 days, 11 hours, 45 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:23:53 PM GMT
In this step-by-step Python tutorial, you'll get a solid understanding of the limitations of Django migrations by tackling a well known problem: creating an index in Django with no downtime. (more)
category: Django | clicked: 1 | comment | | source: realpython.com
tags: ORM, PostgreSQL, SQL
1
likes
spam Like Dislike

Fastest Way to Load Data Into PostgreSQL Using Python

published 830 days, 8 hours, 25 minutes ago posted by matthewpomarmatthewpomar 839 days, 11 hours, 50 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:18:20 PM GMT
Explore the best way to import messy data from remote source into PostgreSQL using Python and Psycopg2. The data is big, fetched from a remote source, and needs to be cleaned and transformed. (more)
category: PostgreSQL | clicked: 7 | comment | | source: hakibenita.com
tags: Performance, Python
1
likes
spam Like Dislike

How to Get the First or Last Value in a Group Using Group By in SQL

published 830 days, 8 hours, 25 minutes ago posted by matthewpomarmatthewpomar 839 days, 11 hours, 51 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:17:36 PM GMT
Getting the last value of a group in an aggregated query in PostgreSQL is a challenging task. In this article we present a simple way to get the first or last value of a group using group by. (more)
category: PostgreSQL | clicked: 1 | comment | | source: hakibenita.com
tags: SQL
1
likes
spam Like Dislike

How To Prevent SQL Injection Attacks With Python

published 830 days, 8 hours, 25 minutes ago posted by matthewpomarmatthewpomar 839 days, 11 hours, 53 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:15:20 PM GMT
SQL injection attacks are one of the most common web application security threat and one of the easiest to prevent. Web application attackers will surely test your web application for this security vulnerability so you must take steps to ensure that this security hole is plugged, and plugged fast! SQL injection attacks are made possible by allowing non-escaped single or double quote strings to be included in your database's SQL call. This can be done very easily by an attacker by including a partial SQL... (more)
category: Python | clicked: 7 | 1 comment | | source: realpython.com
tags: ORM, PostgreSQL, Security, SQL
Previous 1 2 Next