Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Jul 20 21:58
    Matej-ch opened #288
  • Jul 12 09:22
    ashaduri commented #286
  • Jul 08 06:18
    chunlaw commented #286
  • Jul 08 06:17
    chunlaw commented #286
  • Jul 08 06:17
    chunlaw commented #286
  • Jul 08 06:17
    chunlaw commented #286
  • Jun 22 07:31
    handcode commented #232
  • Jun 22 07:01
    handcode commented #232
  • May 20 10:02
    helprepair starred bedezign/yii2-audit
  • Apr 01 23:46
    thtmorais edited #284
  • Mar 31 15:33
    lmribeiro starred bedezign/yii2-audit
  • Dec 18 2021 15:50
    lloyd966 opened #287
  • Dec 15 2021 08:48
    ashaduri opened #286
  • Dec 14 2021 09:03
    eluhr starred bedezign/yii2-audit
  • Dec 05 2021 16:02
    lloyd966 commented #285
  • Dec 03 2021 14:22
    lloyd966 opened #285
  • Nov 02 2021 08:42
    mazfreelance starred bedezign/yii2-audit
  • Oct 06 2021 11:02
    lucianolima00 starred bedezign/yii2-audit
  • Oct 05 2021 20:11
    thtmorais commented #284
  • Oct 05 2021 20:01
    thtmorais synchronize #284
Abayomi Osamiluyi
@yomexzo
is there a way to inform the behavior which fields i don’t want tracked
Steve Guns
@Blizzke
yeah just specify it as a configuration array instead of just the class name and fill the ignored property
Abayomi Osamiluyi
@yomexzo
coolio
Steve Guns
@Blizzke
so you will be using it mainly for database changes then?
or are you planning to use the error/request logging as well
Abayomi Osamiluyi
@yomexzo
yes. pretty much
Steve Guns
@Blizzke
k
Abayomi Osamiluyi
@yomexzo
saw the error/request logging tool. cook feature
Steve Guns
@Blizzke
that is the basic functionality of the component
Abayomi Osamiluyi
@yomexzo
but the database changes is P1 for me right now
Steve Guns
@Blizzke
database etc is extra :)
Abayomi Osamiluyi
@yomexzo
oh. lol. will take a closer look then
looks tedious seeing several rows/entries per action tho
i create a post
and the change on id, title, and body appear separately
can’t have it say model x was updated. fields a, b, c were updated. their old values and new values
Steve Guns
@Blizzke
they are linked to a single request
if you browse via the entry instead of directly via the auditing you get them per request
via the audit its basically a grid of the table without grouping
Abayomi Osamiluyi
@yomexzo
i see. pardon the quick questions. just excited and wanted have the questions answered quick. yet to look well
Steve Guns
@Blizzke
no worries
Abayomi Osamiluyi
@yomexzo
shared with team mates already. and they like
Steve Guns
@Blizzke
btw nineinchchikc has also made a very nice component for db auditing only, based on triggers etc
Abayomi Osamiluyi
@yomexzo
link to repo?
if you are looking for just that, that might be interesting also
Abayomi Osamiluyi
@yomexzo
lol .. same repo name. different accounts. can be confusing to be a fork
Steve Guns
@Blizzke
there's only so much names you can come up with for similar functionality
Abayomi Osamiluyi
@yomexzo
right. makes sense
Steve Guns
@Blizzke
they were developed paralel
John is here in the channel and we're looking into integrating everything together
Abayomi Osamiluyi
@yomexzo
awesome!
since this is involves dealing with large data set, searching and rendering. can i ask a question related to mysql data and querying for reports here?
or wrong place?
Steve Guns
@Blizzke
you can try, i'll see what i can do :)
no guarantees though
Abayomi Osamiluyi
@yomexzo
awesome!
i have a table of about 1million records
each record has the date/time it was inserted and who inserted it
and when it was last updated and who updated it
and, who created might be different from the last person that updated
table has about 30 columns and is currently 716.7Mib
problem now is querying it for information based on the created time, who created, last updated time, who updated last runs into 25seconds
or even more
following? making any sense?
Steve Guns
@Blizzke
i am and yes
I assume you added the necessary indexes?
Abayomi Osamiluyi
@yomexzo
yes. have indexes. but don’t quite understand fully the impacts
let me show you a sample query to get the full picture
Abayomi Osamiluyi
@yomexzo
sigh. stuff requires a lot of background knowledge.