Top Tweets for #VettabaseWeeklyTips
You can instruct @ProxySQL to retry a query a certain number of times in case of failures: SELECT /* ;query_retries=3 */ * FROM ... #ProxySQL #opensource #MySQL #VettabaseWeeklyTips #techcommunity
If you want to use prepared statements, make sure that they are actually reused in the same connection. Otherwise, you'll hardly see any benefit from them. #Database #DBMS #opensource #techcommunity #VettabaseWeeklyTips
Different DBMSs have a different set of keywords that shouldn't be used as table/column names. To know if a word is a reserved word, check if this SQL query returns an error: SELECT 1 AS word; #Database #databases #storage #opensource #SQL #VettabaseWeeklyTips #naming #keywords
Are you tired of using CONCAT() in #SQL queries? Recent @MariaDB versions have SFORMAT(), which supports string interpolation. It's a bridge to the #fmt library, used in #Python and other #programming languages. #opensource #MariaDB #VettabaseWeeklyTips #database #storage
Almost any #database pro is able to restore a #backup, especially in the cloud. However, it can take too much time, and many things may go wrong. You should have #restore scripts in place, and test them regularly. #databaseautomation #Database #Vettabase #VettabaseWeeklyTips
Did you know that @MariaDB has a UUID data type? Using it will make your searches faster and save space without having to modify your queries. #MariaDB #opensource #database #Vettabase #VettabaseWeeklyTips
Amazon #Redshift has arrays, but they're very limited. Bear in mind that you can't loop over an #array in a stored procedure. #Cloud #database #Vettabase #VettabaseWeeklyTips
Did you know that @Ansible inventories can contain host and group variables? Things like @PrometheusIO hostname and port, for example, are inventory-related variables that should go there. #Ansible #Prometheus #automation #Vettabase #VettabaseWeeklyTips
Note that @MariaDB has an #Oracle compatibility mode that will allow you to run most SQL queries and even most stored procedures developed for Oracle. #MariaDB #opensource #database #Vettabase #VettabaseWeeklyTips
If you use @MariaDB or @MySQL, the easiest way to see the structure of a table is the SHOW CREATE TABLE command. #MariaDB #MySQL #database #Vettabase #VettabaseWeeklyTips #opensource
When we define a @PostgreSQL sequence, we can assign it a cache. This can improve performance but bear in mind that, if values are generated concurrently by multiple connections, they won't be sorted chronologically. #PostgreSQL #opensource #database #VettabaseWeeklyTips
When creating a @PostgreSQL temporary table in a transaction, you can specify what will happen ON COMMIT. The options are: PRESERVE ROWS, DELETE ROWS, or DROP. #PostgreSQL #transactions
#opensource #VettabaseWeeklyTips
In @PostgreSQL, if you have an append-only table, you can use a partitioned table and periodically rotate...DELETE could make the table bloat or require more aggressive autovacuum. #PostgreSQL #opensource #VettabaseWeeklyTips
Be aware that @PostgreSQL logical replication only replicates tables. For example, it won't replicate large objects or materialised views. #PostgreSQL #opensource #VettabaseWeeklyTips
In @PostgreSQL, the large object interface is partially obsoleted by TOAST columns. However, while TOAST supports up to 1G, a large object can take up to 4T. #PostgreSQL #opensource #VettabaseWeeklyTips
With @PostgreSQL, you should monitor if a transaction ID (XID) #wraparound is close. If it is, an automated script should kill the oldest active transaction. #PostgreSQL #VettabaseWeeklyTips #opensource
Did you know that @Ansible inventories allow us to use any name for hosts, and then specify the real address with ansible_host? Doing so is a great idea if you have obscure or inconsistent hostnames, or no hostnames at all. #Ansible #automation #Vettabase #VettabaseWeeklyTips
In theory, #Vagrant can launch any type of VM, container, or even #cloud instances, and join them in a private network with components that are almost the same as production. #security #automation #opensource #Vettabase #VettabaseWeeklyTips
If you allow human users to connect to your databases directly, use roles to make permissions much easier to track and manage. Major DBMSs, including @MariaDB, @MySQL, and @PostgreSQL, support roles. #MariaDB #MySQL #PostgreSQL #opensource #Vettabase #VettabaseWeeklyTips
Last Seen Hashtags on Sotwe
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
240.4M followers
Barack Obama
@barackobama
119.3M followers
Donald J. Trump
@realdonaldtrump
111.7M followers
Cristiano Ronaldo
@cristiano
110M followers
Narendra Modi
@narendramodi
107M followers
Rihanna
@rihanna
97.5M followers
NASA
@nasa
92.1M followers
Justin Bieber
@justinbieber
90.8M followers
KATY PERRY
@katyperry
87.3M followers
Taylor Swift
@taylorswift13
81.2M followers
Lady Gaga
@ladygaga
72.7M followers
Kim Kardashian
@kimkardashian
69.6M followers
Virat Kohli
@imvkohli
69.4M followers
YouTube
@youtube
68.6M followers
Bill Gates
@billgates
63.7M followers
The Ellen Show
@theellenshow
62.5M followers
Neymar Jr
@neymarjr
62.1M followers
CNN
@cnn
61.9M followers
X
@x
60.9M followers
Selena Gomez
@selenagomez
60.4M followers