Sydney

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

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.

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

Think you’re fluent in chess? 🤔 Now, you can test yourself against your favorite @duolingo characters—Oscar, Junior, Zari, Lily, and Duo—in 12 different languages! 🤩

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

Hi all, this is Ady’s wife, Rachael. I’m devastated to share the news that Ady has died from complications of ALS. You probably knew Ady as a healthcare activist. But more importantly he was a wonderful dad and my life partner for 18 years. [1/4]

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!

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

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

@MERN_Man_Luke deleting my account now

@MERN_Man_Luke Omg

@luiswe3_ Oops same 🙈

I wish there was a math camp for adults

Something has changed.

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

@githudd I wish there were way more things for adults that we as a society arbitrarily said no more of after highschool/college unless you could do it at a competitive level. Gotta be one of my favorite things about video games

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

@hot_girl_spring The worst years of my life lol

@moracodes No ☹️ can’t hear myself think

Can you code to music with lyrics?

@MERN_Man_Luke Sending this to my valentine

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

I'm not joking when I say there should be laws against forcing your employees to bully customers into getting retail credit cards. It was the absolute worst thing about working at the Gap.

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?

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