Sydney

Solutions Architect 👩🏻‍💻

[Sydney @githudd]

has anyone reading this ever run their discord bot from a raspberry pi?

[Nikki Siapno @NikkiSiapno]

Database Indexing Explained.

Most databases require some form of indexing to keep up with performance benchmarks.

Searching through a database is much simpler when the data is correctly indexed, which improves the system's overall performance.

A database index is a lot like the index on the back of a book. It saves you time and energy by allowing you to easily find what you're looking for without having to flick through every page.

Database indexes work the same way. An index is a key-value pair where the key is used to search for data instead of the corresponding indexed column(s), and the value is a pointer to the relevant row(s) in the table.

To get the most out of your database, you should use the right index type for the job.

The B-tree is one of the most commonly used indexing structures where keys are hierarchically sorted. When searching data, the tree is traversed down to the leaf node that contains the appropriate key and pointer to the relevant rows in the table. B-tree is most commonly used because of its efficiency in storing and searching through ordered data. Their balanced structure means that all keys can be accessed in the same number of steps, making performance consistent.

Hash indexes are best used when you are searching for an exact value match. The key component of a hash index is the hash function. When searching for a specific value, the search value is passed through a hash function which returns a hash value. That hash value tells the database where the key and pointers are located in the hash table.

Bitmap indexing is used for columns with few unique values. Each bitmap represents a unique value. A bitmap indicates the presence or absence of a value in a dataset, using 1’s & 0’s. For existing values, the position of the 1 in the bitmap shows the location of the row in the table. Bitmap indexes are very effective in handling complex queries where multiple columns are used.

When you are indexing a table, make sure to carefully select the columns to be indexed based on the most frequently used columns in WHERE clauses.

A composite index may be used when multiple columns are often used in a WHERE clause together. With a composite index, a combination of two or more columns are used to create a concatenated key. The keys are then stored based on the index strategy, such as the options mentioned above.

Indexing can be a double-edged sword. It significantly speeds up queries, but it also takes up storage space and adds overhead to operations. Balancing performance & optimal storage is crucial to get the most out of your database without introducing inefficiencies.

[Sydney @githudd]

@chesscom @duolingo Partnership between my two most used apps is very exciting! But am I able to select/change the language the characters are speaking during a game?

[Sydney @githudd]

@AdyBarkan Sending my condolences. He was a wonderful human. ❤️❤️❤️

[Coby @Cobylefko]

On hot & sunny days, I’m reminded that one of the best things cities can do to cool off is to plant as many trees as they can.

The benefits of trees go well beyond this (like stress reduction, & cleaner air) but it’s tough to think about anything else when it’s so hot out!

[Stentaröl @StentAprica]

Thank you @developeraspire for writing this helpful article.

JavaScript Operators and Operator Precedence – Beginner's Guide

https://t.co/e9vkgUoRWA

[gaut @0xgaut]

If your boss looks like this, your company will survive the recession

[Sydney @githudd]

@MERN_Man_Luke deleting my account now

[Sydney @githudd]

@MERN_Man_Luke Omg

[Sydney @githudd]

@luiswe3_ Oops same 🙈

[Sydney @githudd]

I wish there was a math camp for adults

[Vitto Rivabella @VittoStack]

Something has changed.

[Sydney @githudd]

@the_codedog I agree!! And that’s cool, are you a competitive gamer?

[Ale (pikacodes) @pikacodes]

next time you’re thinking about leaving a comment on my PR remember this is what i look like

[Sydney @githudd]

@hot_girl_spring The worst years of my life lol

[Sydney @githudd]

@moracodes No ☹️ can’t hear myself think

[Sydney @githudd]

@MERN_Man_Luke Sending this to my valentine

[Sydney @githudd]

@notcapnamerica Gap effed up my credit when I was 18 because I was dumb, slightly misled and thought I was signing up for a rewards card. Credit has since recovered because it was 10 years ago but sheesh!

[Chau @justinbchau]

For those that suck at math and hated it in school, did you ever get back to learning it on your own and was it a better experience if you did?

Follow up is, was it worth it?

[Sydney @githudd]

@Chau_codes Yes! I wanted to challenge the limiting beliefs I held about myself - main one being “I’m bad at math”. For about 3 years I’ve been re-learning it from the ground up and actually enjoying it so much.