Welcome to the Lounge

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

toggl.com
I don't think it gives you the sql part but what you are after (reporting) is included already.
I have been using it for many years. I like it. It is easy to use. But one issue I had (prior version) was something you specifically asked for - the mobile app - it didn't work well on ios. That may have changed/improved.

1. debugging in Visual Studio is pathetic -- it requires this alpha release of their test tool. Really?

2. Instead of hitting the endpoint at localhost:5050, you have to create the JSON that simulates the input as it comes in to the lambda function.

3. When using the alpha test tool (I can see why they call it "alpha") your function handler has to be defined with a JObject parameter. Can't use Stream, even though that works just great otherwise.

4. Apparently it has no clue how to load dependent assemblies. Which means any additional project references fail with an "assembly not found" error.

5. So to do any testing, I end up having to publish the function because that's the only way to "debug" it -- with try-catch handlers and "contract" tests to figure out what's wrong.

I can write a better test tool in a day, what moron do they have working on this. Hmmm. Good 4th of July project. Maybe someone's already done this? Don't want to re-invent the wheel, haha, though many wheels I find are rather flat, broken, and lying in a rut covered in mud.

It's been noticed already: Bugs and Suggestions[^]
I've found a workaround: I can open any forum in "Normal" if I open it from a browser bookmark - but anything you do to it and it snaps back to "Open all". Hopefully Canada will be on office hours shortly and it'll get fixed.

Got a renewal recently, they wants £252.30, 14% more than last year - in a year when car insurance prices have dropped by 7% across the UK.
So, Mr Annoying Opera Singer, let's see what you got ... Oh, you have my details from last time? excellent, no they haven't changed.
Top quote: £170.13 with the AA
Second quote: £191.58 with ... the company I'm with at the moment ... Hmmm ...

Ring them, and explain: confirm details, and suddenly they can quote me £184.16 for the same cover I had last year, with the same protected no-claims, same car, same address, ... same me!

I hate insurance companies. but computerised comparison sites do help!

all will be fine, happy and good until the day you need to make a claim.

A couple of supporting stories:
1. My mom was sitting in her car in a parking lot one time. She hadn't even put the keys in the car. A wild-driving kid raced up fast into the parking space behind her and didn't stop in time and bumped her. She got out and talked to the kid and there was no damage at all. She let the kid go, not trying to make a big deal of it. But then after he left she thought, "what if he says I hit him or something?" She called her insurance company just to ask about it.
3 weeks later her rates went up. She called and asked why and they mentioned the parking lot incident. Monsters!

2. My son was driving on a street with no stops signs or lights or reasons to stop. A guy in a large truck, waiting in a parking lot, pulled out in front of my son. He slammed on brakes and slid and almost missed the guy, but he just touched the guy's truck.
The guy went crazy saying that my son hit him. My son said, "there's not damage and I'm in a hurry to work, why even get police involved?"
The guy went nuts.
Police came and the guy was arguing and yelling. Policeman said, "there's no damage and you pulled out in front of him." Guy kept yelling.
The policeman came to my son and sheepishly said, "I'm not going to cite anyone, just to get him to calm down."
Days later our insurance called us and said, "Hey, your son had a wreck."
The other guy had reported it to his company -- it was their truck and he was late to work and needed an excuse. Company called police and got report and reported it to insurance.
No one was cited. Because the other company reported it our insurance company said he was involved in a wreck. Rates went up. Monsters!!
We should've fought to have the other guy cited. But we were being nice to the policeman trying to help him get the guy calmed down. Terrible!

Years ago I parked near a customer workshop, the car was parked near a tall wall (10 meters +/-) on top of that wall there was a house where two old persons lived.

I went to work and after some hours I left.

When I entered the car I started it and I heard a super loud noise when I started to move... Of course I step down the car and went the other side (the side near the wall).

I saw all the car side completely devastated... no side mirror, my rear bumper touching the floor and the front bumper under the front wheel...

That day there was a lot of wind and those lovely couple had a big bar "fixing" a provisional roof... With the wind the roof flew and the bar fell down against my car... bouncing several times between the wall and the car...

Of course I went to those old people house and told them what happened.

They were super worried and scared and gave me their insurance contact and details.

They called their insurance to explain what happened.

I called them a couple of days after.

They told me unless I would denounce them they wouldn't move a finger...

After 4 years, my insurance called me to ask my bank account to send me the money of that accident.

I got the money, but it was terrible to see how they made those old people suffering for nothing...

They are not monsters... that is not close enough of what they really are...

If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.

This applies to any large subscription model, existing customers you slowly (or not) creep up the premium/renewal cost. New customers get an introductory price, it's all about expanding the subscription base and a large % of customers just renew without any research.

As for the comparison sites they are not always good. Recently renewed our house insurance and the comparisons were 40% higher than my current premium. I rang up and bitched at them anyway and got it reduced by over $700.

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

I went off road, unintentionally a couple of weeks ago. My car was valued for insurance (based on their evaluation) at £2400, but its list price magically changed to £1050 when they came to pay me for it being written off. I don't quite know how the system works but I've also been getting lots of calls from companies claiming they have been authorised by my insurers to get money back from the other parties involved in the incident; which is odd as the insurers know that there were no other parties. These other companies then have the gall to ask about other occupants in the car (so they can get them to make claims against me), even though the insurers know that I was the sole occupant. [Just in case anyone cares: The car was a write-off, but I walked out unscathed (I had to clamber over to the back seats to get out as both front doors were too smashed up to open)].

It's funny how that works, isn't it?
They are perfectly happy to accept your estimate of value when quoting you for cover, but only accept theirs when it's time to pay up ... I've noticed that a couple of times with motorcycle thefts.