Sydney @githudd

Solutions Architect 👩🏻‍💻 ATX Joined January 2022

Tweets

818
Followers

2K
Following

719
Likes

5K

Sydney @githudd

2 years ago

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

2 0 7 425 0

View Details

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.

13 402 2K 248K 1K

View Details

Sydney @githudd

3 years ago

@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?

0 0 0 129 0

View Details

Sydney @githudd

3 years ago

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

0 0 0 20 0

View Details

Coby @Cobylefko

3 years ago

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!

6 32 247 18K 5

View Details

Stentaröl @StentAprica

3 years ago

Thank you @developeraspire for writing this helpful article. JavaScript Operators and Operator Precedence – Beginner's Guide freecodecamp.org/news/javascrip…

0 2 5 615 0

View Details

gaut @0xgaut

3 years ago

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

834 16K 216K 12.9M 3K

View Details

Sydney @githudd

3 years ago

@MERN_Man_Luke deleting my account now

0 0 1 90 0

View Details

Sydney @githudd

3 years ago

@MERN_Man_Luke Omg

0 0 0 51 0

View Details

Sydney @githudd

3 years ago

@luiswe3_ Oops same 🙈

0 0 1 130 0

View Details

Sydney @githudd

3 years ago

I wish there was a math camp for adults

2 0 9 420 1

View Details

Vitto Rivabella @VittoStack

3 years ago

Something has changed.

18 34 379 18K 1

View Details

Sydney @githudd

3 years ago

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

1 0 1 19 0

View Details

Ale (pikacodes) @pikacodes

3 years ago

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

48 89 2K 134K 51

View Details

Sydney @githudd

3 years ago

@hot_girl_spring The worst years of my life lol

0 0 1 61 0

View Details

Sydney @githudd

3 years ago

@moracodes No ☹️ can’t hear myself think

0 0 1 63 0

View Details

Sydney @githudd

3 years ago

@MERN_Man_Luke Sending this to my valentine

0 0 1 128 0

View Details

Sydney @githudd

3 years ago

@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!

0 0 1 342 0

View Details

Chau @justinbchau

3 years ago

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?

25 3 75 23K 6

View Details

Sydney @githudd

3 years ago

@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.