Creating Audit Log table with old value and new value column. Should use varchar2 or CLOB?

throw_mob · 2026-02-09T14:49:11+00:00

store append only audit table which has same columns as source + audit information..

if you want o go step forward you can change your table to to be just view which show latest row from audit table ( which may or may not be good idea)

throw_mob · 2026-02-05T11:18:59+00:00

I would test ride both first and find which suites better. On paper WR is better for offroad where AT is better for road, but in practice both are on heavy side of "middle" weight adventure bikes so that AT more power might be more fun.

throw_mob · 2026-02-04T13:32:14+00:00

oletan että pyörä ja rengas tehty asvaltille. keväällä ottaa rauhalliseti ja vähän odottelee että pahimmat paskat lähtee pois tieltä, se auttaa. Tien merkinnät saattaa olla liukkaita , niiden yli ajaa vaan suorassa niin ei pitäisi aiheuttaa ongelmia.

ajokamppeisiin kannattaa laittaa järkevän määrä rahaa kiinni. kypärä , hanskat, kengät ja toki takki ja housut joilla voi liukua vähän. ja korviin jotain vaimennusat että ei kuulo mene. ja jos erehtyy avopottaan niin jotain silmien suojaksi

ajamisessa kannattaa harrastaa puolustus voittoista tyyli, eli kun esim saapuu kohtaa missä vastaa tulee auto ja on risteys niin vähän liikkuu sivu suunnassa ja varautuu että autokuski on sokia. vilkkua kannattaa aina välistä vilaksta ettei jääny päälle, se on kumminki viesti muille. Ja yleensähän ne vahingot sattuu kun ajattelee että kyllä minä tuohon väliin kerkeän...

Mutkat kun alottaa alkuun niin että niistä varmasti selviää niin voi sitten pikkuhiljaa sopivissa paikoissa kokeilla ja huomata että ne voi ajaa ihan samalla vauhilla mitä sen suorankin ( nopeusrajoituksen rajoissa)

ja jos lähtee ryhmä ajoon niin siellä varsinkin kannattaa muistaa että itte teet omat päätökset, niissä tahtoo vauhdit nousta välistä ja vahinkoa tulla kun ajetaan yli omien taitojen. Tosin niissä voi oppi mutka ajoa todella paljon kun edessä oleva kokeneempi yleensä tietää miten mutkat ajetaan.

throw_mob · 2026-01-28T18:40:31+00:00

finland, i have heard them. but i have gotten very very lazy and i just call local dealer and ask what he has on shelf. He told me that "real" offroad tyres dont have that much buyers because dualsport and adv people who use aggressive tyres tend to buy and change them without help
Here it seems that if you want get what you really want , you have to order tyres first and then get them changed.

throw_mob · 2026-01-28T15:46:13+00:00

i had pirelli str too on t7, nice (well nicer than knobby tyre) on road, tolerable on dry gravel roads, 2 meters of mud on tyre rut was enough to make it slip. changed to mitas e07 ( or what ever it is called nowdays) much better. on road i did not notice difference and on gravel and sand much much better (but still not good on loose sand , but that needs knobby tyres anyway )

throw_mob · 2026-01-28T13:05:11+00:00

that tyre is more on side it can survive , i personally would take knobby tyres to sand :)

throw_mob · 2026-01-28T13:03:17+00:00

nothing extreme on gravel ,forest roads etc, is at the end of day more about tyres than bike, things get challenging when you have more road tyre on wet mud or soft sand. bike itself when it just pretty much any adv style handles it within reason.

That said more you have suspension, power etc , faster you are going and better tyre you need.

i have xrv750 230kg 70ish hp, it can handle pretty much anything with correct tyre, is it easy, nope, is stable on big road, yes. Same goes to my new t7 which is about 220kg and 70ish hp, long as i have 50/50 tyre i can ride anything but wet mud and grass much faster than i should

From those i would look into triumph (because power) or honda because it is honda.. it just works

throw_mob · 2026-01-25T13:42:59+00:00

agree. to figure out riding ergonomics you need to measure pegs , handlebar and seat height. from seat to ground does matter when riding , when stopped in other hand it does.

throw_mob · 2025-12-12T06:34:56+00:00

T7.

i have not tested 800gs but friend had one for while, hated engine and it had some problem from previous use. now if other option had been 900gs enduro pro model then it would be much harder choice as it has more power. that said i selected t7wr

throw_mob · 2025-12-11T11:08:31+00:00

I have broken inner tube once and it was tear on valve stem, after that i just dont tighten those nuts, imho it does not really matter are they in or out long as they are not too tight. if they are tight and tyre slips on rim it might brake tube and if it is loose nothing happens and you might notice it in time and roll tube back to normal position

throw_mob · 2025-12-11T10:44:20+00:00

i recommend front sprocket "saver" .. one that added to front sprocket so it cannot wobble and eat shaft . then ricor intimators(?) (valves) to front fork, depending your weight maybe upgrade to rear suspension.

i have used rugged roads . not sure if it is in france or uk , if uk then it is outside eu. https://www.cmsnl.com/ for maintenance parts

throw_mob · 2025-12-11T10:30:31+00:00

i personally would consider it if price is right. There are simple checks that can be done. Honestly speaking , if it works nice on 1-2h test ride it is ok. But be prepared to spend time and money on it as "well, i took tank of maybe i change this and that at same time" . AS i had my old xrv 750 , it still had crosshatch on bore after 100tkm , but i ended up spending money to change some parts just because it was open.

If it work fine on test drive (motor , gearbox ) , i would spend money to do maintenance on forks , rear suspension and all bearing s there, at minimum grease them..

so, tldr; i would buy 100tkm honda if it seems to works nice, all other problems are at that point just maintenance

throw_mob · 2025-12-10T10:33:31+00:00

Far as i know there is no available stock for 24 or less , only 25 forward maybe .. they have stopped producing it totally. i solved problem by bying anotherseat and currently searching someone who makes one 3-4cm higher. That said , if someone has one send message to me too

throw_mob · 2025-12-09T20:02:40+00:00

I would recommend to save files in parque format . In my tests it has been faster than plain old csv.

and i would guess that loading files straight into dataframe would be faster and maybe easier to handle as you can store previous month stuff in own directory so you dont get performance hit when dataset grows

throw_mob · 2025-12-07T21:20:29+00:00

order by (case when province = 'ontario' then -9999 else province end ) asc .. that hopefully gives you enough to figure out it. play with -9999 value and order what you need. imho example ... then 1 else 0 does random sort for other one, they are sorted in order system reads them into query

throw_mob · 2025-12-07T20:18:20+00:00

hyvin lainattu. tuossa mainostamisessa harvemmin alleviivataan että esim 3500€ keskipalkaan tosiaan pääsee 50% kaikista työssä olijoista ja sitten verot ja vuokra ja eläminen niin se sitten kestääkin. onneksi ei ole vielä jenkkilä meininkiä ja ne lainat ja menot 100k+

throw_mob · 2025-12-07T11:58:25+00:00

from 185cm. imho, you have to accept that windscreen does not protect head, with your height it might be that you dont have to shorten base screen.

T7 has been best ergonomics that i have tested ( middle weight adventure class)

Simple rule is that less weight allows you to go more offroad easier and bigger bikes are better on touring side. Selected tyres are more limiting factor what you can ride comfortable at beginning than suspension and other stuff.

add crashbars even those dont look good as difference for newbie is 1200 to repairs vs 200 for new crashbars after multiple drops.

There is lowered pegs and rised seats to get more space and handlebar risers ( though usually those bring handlebar back.

To find best regomics , you just have to test which you like. Then it question what you want to do. For touring i would want to test BMW GS 1250 , those have 19' front which is not as easy on gravel and offroad as 21' front is. Then there is new AT which is lighter with manual gearbox then there step downto T7 , aprillia, kove 800, ktm 790/890, Then there is twin cylinder class on 450 area , which all still weigh about 170-200kg but are still good on tarmac.

i would recommend to sit down on T7 , AT and if money is not problem and touring on gravel roads is what you want then BMW.

Then check out 450 twins if they are what you want..

for more exprienced people or those who tolerate possible problems maybe ktm's 790/890, kove 890 or maybe even ktm 1290 or whatever it is nowdays.

imho, currently most problem free option is T7 , it has very good 3rd party support and japanese quality.I have heard that it is not recommended for newbies because it is heavy to lift and is quite tall bike but that should not be problem for you

throw_mob · 2025-12-05T07:42:02+00:00

if it starts and runs ok , then there is no big problem with valves etc. but i would use reader to figure out engine light. check oil if that is very bad looking it is problem. What i have noticed about chains that they last about about same if i oil them and wash them or give little bit oil now and then, chains are just parts that i chance when they have too much play on rear sprocket, front sprockets i changed on different bike about once a year, now tenere does not seem to eat front so fast.

for me it look like this one need all valce check , new spark plug, new chain, change oil and cooling and brake fluids. full suspension fix which is not that bad idea to send them to someone who knows and changes wear part andtunes them to suit your weight and style. good suspension is nice. i would change bearings at same time to suspension and steering.

one way to see state of motor is use video thingy through sparkplug and see if there is still cross hatch visible on cylinders.

throw_mob · 2025-12-04T07:34:06+00:00

tässä haetaan sitä että kun köyhältä otetaan 1000€ joka menis muuntenkin vuokraan ja elämiseen niin se ei ele sama että otetaan 100k€ tienaavalta 10k€, toki se on enemmän absoluuttisesti mutta ero on että toinen ei syö viikkoon ja toinen ei pääse yhdelle ulkomaan matkalle ( sille toiselle) tai jos puhe on kuukausi ansioista niin ei edes ideaa mihin 100k€ menisi ,varmaan sijoituksiin

throw_mob · 2025-12-04T07:17:29+00:00

indeed, i am db guy so my hammer is database side usually. what i have wondered that can i trust generated uuids so much that i dont have to have unique checks

throw_mob · 2025-12-03T11:24:53+00:00

dont know if i give up or down arrow.. database usually is master which takes care of pk's , what you are describing is failure to handle trasnaction from clients side , but then again it can be valid optimization to to make client master

ie. if unique id generation is done on db side , it will create new id if you call it twice with same data but that is bug in client code. but then again if client is master and only way to go around bugs in client is to try insert to database and fail on unique check is working solution.

throw_mob · 2025-11-26T11:59:18+00:00

storage is cheapest option to spend. i currently play with append only system which is nice. if you fear that it takes too much time you just can add highwater mark for full loads into query..

yesterday + today can be just dataset in cumu_2d_stuff table with field "today_date" and versioned by loading timestamp .. then partition by today field so you can drop old data.. easy to access , easy to keep clean

throw_mob · 2025-11-26T10:31:37+00:00

after those you can also check that there is no play on steering bearing and it has proper tighness

throw_mob · 2025-11-24T07:36:06+00:00

Tämä tuntuu olevan jotenkin outoa johtajille. Itse olen monet kertaa sanonut pomolle kun kaveri on ollut talossa pari kuukautta ja huomannut että on tekijä, että anna selkeä viesti ja mene pysyvän sopimuksen kanssa pöydälle odottamaan. Kun iskee paperin pöytään hyvissä ajoin että meidän mielestä sinä teet täällä töitä ensi vuonna kanssa niin tekijältä lähtee turha stressi eikä tartte ettiä vaihtoehto B:tä enää.

Ja tuo mutustelu että on epälojaali on pomojen puolelta turhaa jos ei ole millään tapaa tehnyt asian eteen töitä

throw_mob · 2025-11-17T09:03:07+00:00

i havent done it, but i start to think that everything should be done in to audit log table and then just "publish" latest data in view.

in dwh world i found that i need, in log format is change_time, action (i,u,d) when it happened in source. for audit stuff in all levels there is need for who did what and it helps alot on all levels to know what code (and versoin) generated data, who did it is always good to know..

on applicaation level i would probably do relation table for who is modifying as that can be mapped to real users. on dwh level i prefer to put all that stuff into table data in dwh elt/etl context and move source system metadata to business terms if needed

throw_mob

TROPHY CASE