►
From YouTube: Database Office Hours 2020-06-17
Description
No description was provided for this meeting.
If this is YOUR meeting, an easy way to fix this is to add a description to your video, wherever mtngs.io found it (probably YouTube).
A
A
Thank
you
with
some
lady.
Okay,
welcome
everyone
to
the
database
office
hours
so
address
has
the
first
point,
but
I,
don't
think
he's
here,
yep
he's
not
here
so
I'm
just
going
to
read
it.
We
duplicated
the
use
of
get
lab
data
base
bulk
insert
in
favor
of
leveraging
new
rails,
insert
all
API
so
going
forward.
We
need
to
use
the
new
concern
and
it
seems
to
be
already
documented,
so
yay.
A
A
B
B
B
Yeah,
this
is
just
a
question,
so
I'm
planning
to
update
large
volume
of
user
records
and
basically
I
have
to
send
not
send
but
I'm
confirming
accounts
and
one
confirm
a
user
account.
I
would
be
to
run
the
users
in
a
loop,
so
I
have
to
load
that
through
the
database
and
I
was
looking
for
a
way.
If
I
can
actually
back
update
records
and
found
this
md5
have
bad
metal.
It
was
just
where
you
can
just
pass
some
kind
of
string
and
it
will
give
you
kind
of
like
a
random.
B
String
out
so
you
can
use
it
as
a
verification
to
careful
or
device
and
yeah.
My
question
is
that
do
you
see
any
any
issues
using
this
I
would
probably
put
also
a
timestamp
column
in
the
you
know
the
argument
list
and
maybe
the
encrypted
password.
So
you
cannot
give
a
calculated
upfront.
So
it's
kind
of
secure.
B
D
Yeah,
ideally
the
hash
functions,
risks
colliding
collisions
and
what
you
have
to
do
is
something
called
format:
preserving
encryption
or
something
like
that.
I
had
a
jam
which
I
built
you
can
copy
the
code
there,
it's
open
source.
So
basically,
if
you
want
to
generate
millions
of
unique
codes,
you
can
use
a
guaranteed
technique
which
may
give
you
reach
may
ensure
that
it's
like
md5
in
not
insurance.
D
You
know,
theoretically,
guaranteed
that
it's
you
so
I
was
before
github
I
was
doing
generating
a
lot
of
promo
codes
for
large
FMCG
companies,
so
they
want
so
I'd.
Like
a
million
unique.
You
know
small
coupons,
coupon
codes
and
that's
why
I
built
better
ruby
gem,
so
it's
using
I,
don't
know
if
you
need
to
put
it
in
the
code
or
gitlab
or
you
do
you
wanna,
do
it
once
you
know.
B
B
D
So
you
have
to
I
mean
the
only
way
to
ensure
uniqueness
is
to
have
a
format
designed
ring
transformation
from
dead
start
idea
to
dead,
finish
ID
or
that
range,
which
is
not
a
hash
because
hash
can
collide,
but
something
which
ensures
it
so
I,
don't
suggest
exactly
my
jam.
But
if
you
need
further
ideas,
you
can
take
it.
Offline
I've
worked
on
that
area
bit
I'm.
B
A
A
But
well,
we
haven't
implemented
that,
as
you
can
see
this
opened
like
eight
months
ago,
but
perhaps
something
that
we
can
retake
and
also
regarding
the
usage
of
generating
like
a
string.
Perhaps
we
should
ask
someone
from
the
application
security
team
to
see
that
is
like
sufficiently
enough
to
guarantee
an
uniqueness.
B
A
A
E
A
Okay-
and
the
next
point
is
mine
and
I
am
here
so
I
have
been
noticing
that
we
keep
adding
more
and
more
columns
to
namespaces
and
namespace
as
well.
As
we
all
know,
it's
a
very
a
high-traffic
table
and
it
is
used
a
lot
throughout
our
code
base
and
I
think
it
is
time
for
us
to
create
namespaces
namespace
in
settings
as
a
one-on-one
relationship
with
namespaces,
which
is
basically
the
same
as
project
settings,
and
that
we
created
some
months
ago
and
I
have
outlined
some
steps
of
how
to
do
it.
A
B
A
Yeah
I
think
the
first
step
is
that
we
can
add
the
namespaces
table
to
our
cup
check.
So
we
woke
up
fails
whenever
someone
is
trying
to
add
a
column,
and
perhaps
we
can
start
a
conversation
like
hey.
Do
you
really
need
to
add
a
column
here?
Perhaps
you
can
create
a
different
table
or
perhaps
you
can
go
into
a
different
table,
but
there
are
something
to
consider
when
reviewing.
D
So
sometimes
I'm
seeing
some
create
tables
which
reference
some
tables
and
I
want
to
see.
If
it's
a
busy
table,
I
go
to
the
documentation
for
BitLocker,
retries
Adam
has
put
there
a
list
or
visit
tables,
which
is
thanks
for
it.
So
how
do
we
define
a
busy
table
like
I?
Have
some
other
table?
Let's
say
a
new
one
and
where's?
What
is
the?
What
is
the
best
way
to
discover
that
a
new
table
is
a
busy
table,
not
the
size,
maybe,
but
also.
B
Yeah,
that's
a
tricky
question
because
size
inside
it
doesn't
really
mean
that
something,
but
that's
not
only
only
constraint,
I
would
say:
that's
not
not
only
on
the
rule,
a
small
table
that
is
often
requested
like
github
subscription
on
github.com.
We
could
also
coaster
that
was
a
busy
table
because
basically,
almost
every
request,
every
first
touches
the
table,
and
if
we
have
a
lock
on
it
for
a
long
period
of
time,
then
we
will.
We
will
see
problems
in
production
so
for
that
initial
list,
I
was
that's
based
on
past
incidents.
B
When
we
had
problems
when
we
added
new
columns
and
try
to
drop
columns
even
doing
some
data
migration,
we
had
basically
production
incidents
on
those
tables
most
of
faster,
faster
main
source.
But
to
be
honest,
we
we
haven't
really
written
down.
You
know
the
exact
definition
of
what
a
busy
busy
table
is.
B
Maybe
we
could
do
some
kind
of
extract
some
statistic
from
that
statement,
so
you
know
how
many
query
this
table
gets
per
minute
and
somehow
have
a
formula
with
the
table,
size
and
and
magically.
We
have
a
formula
for
this.
Ideally
I
mean
for
the
long
term,
but
I'm
not
sure
how
to
how
to
do
it
nicely.
We
could
build
this
we'd
drop
lovely
if
I
helper
into
our
standard
migration
methods.
You
know
what
yes
provides,
but
there
are
some
edge
cases.
So
you
cannot
always
do
that.
B
Yeah,
it's
a
it's
a
tricky
one
I
think
there's
a
first
step.
You
will
need.
You
will
need
to
have
some
rules
written
down
and
probably
this
this
will
be
dynamic
as
a
seed,
lab
data
base
pros
and
and
and
we
start
using
different
parts
of
the
database-
maybe
a
new
feature
really
picks
up
and,
and
it
becomes
like
a
table.
D
Okay,
I'll
open
an
issue
and
ping
you
so
and
I
will
take
it.
So
if
we
have
one
metric
and
we
applied
to
the
existing
visit
tables
than
any
new
table,
which,
like
also
falls
in
the
range
for
similar
to
current
visit
tables,
they
may
consider
it
as
a
you
know,
candidate
for
using
whitlock
retransform.
B
Yeah
yeah,
that
makes
sense,
but
I
know
that
this
sometimes
creates
extra
work
for
for
reviewers
and
also
for
for
authors,
because
you
know
normally,
you
would
think
that
hey
understanding
when
you
column
and
everything
is
okay
and
then
the
reviewer
things
you
that
hey
is
this
extra.
A
steampunk
is
sometimes,
and
it.
A
A
A
D
Point
is
temporarily,
we
are
doing
some
telemetry
reviews
and
part
of
it
is,
you
know.
Checking
some
batch
counter
is
having
queries,
query
plans
which
aren't
quite
hard
to
meet
like
so
we
plan
to
move
the.
You
know
that
review
or
we
want
to
get
rid
of
at
some
point
on
telemetry
review
and
mood
at
SQL
query
checking
for
usage
data
under
the
database
team.
What's
the
best
way
to
do
it,
so
I
was
thinking
first,
we
may
move
or
I
linked
or
documentation.
D
D
So
does
it
make
sense
that,
finally,
they
are
queries
which
are
which
need
to
be
optimized
and
sometimes
in
a
you
know,
in
NMR,
there's
a
database
McHenry
River
and
we
do
a
telemetry
review,
which
is
the
same
thing
as
the
database
review
so
like
in
three
months
or
so
when
or
hot
season
finishes.
Let's
say
we
want
to
move
them
and
I.
Think
a
good
way
to
do
is
just
move
some
of
the.
A
Well,
I,
don't
want
to
speak
for
all
of
them
and
a
nurse,
but
it
makes
sense
to
me
because
we
are
dealing
with
that.
Ra
square
is
basically-
and
this
is
something
that
we
normally
check
when
reviewing
a
merge
request
from
database
perspective.
So
I
would
be
fine
with
it,
but
I
don't
know
what
everyone
else
thinks.
E
C
D
Or
twenty
records
which
works
fine,
but
when
you
do
a
count
or
distinct
count
or
ten
million
or
five
hundred
million
rows,
it
will
fail
and
that's
not
immediately
stable.
So
they
are
a
bit
more
challenging
than
ordinary
queries.
It's
challenging
means
it's
hard
to
see
for,
like
you
just
have
a
simple
line
count
and
then
you
don't
expect
it
to
fail,
but
it's
gonna
fail.
E
I'm,
adding
a
quick
I
might
even
a
quick
guide
for
new
reviewers
I
will
send
it
your
way.
Very
simply,
just
the
the
main
questions
that
we
are
asked
like:
how
do
you,
how
are
you
becoming
a
reviewer?
What
what
to
do?
What
are
the
most
important
things
to
check
before
starting
the
reviewing
and
some
links?
Nothing
more
so
we
send
it
there.
What
is.