Top Tweets for #SevenDatabasesInSevenWeeks
What I like about #SevenDatabasesInSevenWeeks is their attitude to #shell scripts. Usually, they are quite dirty, but here they are rather pretty. At least in naming the variables. Here is where an idiom "God is in the detail" is entirely suitable.
#Database
#MongoDB has an interesting attitude towards working with replicas. It's better to have an odd number of them to reach quorum when having network issues.
#SevenDatabasesInSevenWeeks
In #PostgreSQL there is a notion called stop word. Stop word is a word that is ignored by full-text search. In the English language among them, you can find "a", "the" and other.
The longest stop words are "yourselves" and "themselves".
#SevenDatabasesInSevenWeeks #Database
Hm, #PostgreSQL version 10.6 seems not to have crosstab function.๐ค
#SevenDatabasesInSevenWeeks #Database #SQL
That's quite interesting that in #SQL to run stored procedure you need to use the SELECT command.
SELECT <procedure name>(<procedure arguments>)
#SevenDatabasesInSevenWeeks #Database
Sometimes in #SQL, you want to find out what different values are there in the column. You can use grouping for this:
SELECT <column> FROM <table> GROUP BY <column>;
Or you can do even shorter:
SELECT DISTINCT <column> FROM <table>;
#SevenDatabasesInSevenWeeks #Database
Without practice on the computer, reading some books may become almost useless. You'll get a tiny piece of knowledge that will be forgotten soon. These books in the classification of Mortimer Adler are practice books.
#SevenDatabasesInSevenWeeks #Database
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
241.2M followers
Barack Obama
@barackobama
119.1M followers
Cristiano Ronaldo
@cristiano
112.8M followers
Donald J. Trump
@realdonaldtrump
111.8M followers
Narendra Modi
@narendramodi
107.1M followers
Rihanna
@rihanna
98.3M followers
NASA
@nasa
92.3M followers
Justin Bieber
@justinbieber
91.5M followers
KATY PERRY
@katyperry
89M followers
Taylor Swift
@taylorswift13
82.9M followers
Lady Gaga
@ladygaga
74.4M followers
Virat Kohli
@imvkohli
71.9M followers
Kim Kardashian
@kimkardashian
70.4M followers
YouTube
@youtube
68.8M followers
Neymar Jr
@neymarjr
64.8M followers
Bill Gates
@billgates
64.6M followers
The Ellen Show
@theellenshow
62.4M followers
Selena Gomez
@selenagomez
62.1M followers
CNN
@cnn
61.8M followers
X
@x
60.8M followers