I suspect postgress just brings efficient queries. My initial thought was how fossil uses sqlite as a backing store. but... not only is sqlite intentionally designed as an interchange format(stable specification). the postgress disk structure is intentionally designed to not be a interchange format(they reserve the right to change it at any time) so not that.
So the only real reason is you already have a postgres server and want the efficient query indexes.
I'm not saying this project isn't cool, but whenever you have ANY software that's designed to be hosted A-style, and you host it B-style, the obvious question is "Why not host it the A way?"
I wouldn't say I am a huge proponent of Flock, especially considering their lack luster security for the individual cameras at least in my area, but the title makes it sound like it's an institutional procedure that the department stalking their romantic interests instead of individual officers that need to be properly reprimanded.
It is institutional in the sense that Flock and the individual PDs have not put steps in place (either post auditing or pre not allowing bad queries) that prevent the abuse.
Post auditing is obviously not taken seriously by these departments, and Flock could build tools to do this out of the box (identify weird search patterns) if they wanted to.
Police abuse of power in the US is a systemic problem. Your opinion is akin to thinking the Catholic church bears no burden for all the diddling they neglected to observe.
Do you make any distinction between sheriff's departments that are elected into their office (e.g. Jacksonville Sheriff's Office) vs commissioned LEOs?
I personally wouldn't, both positions are going to attract the same personality and be working in the same culture with the 99% the same influences. Maybe elected sheriffs are a bit better on average, but certainly not enough for it to show through ancedotaly or trust them in any capacity.
Honestly, a great question that I would have to think on. Whatever limits both their power, haha. Not really an answer, but I think what it boils down to is accountability. I work with a lot of state and federal cops. They are good people for the most part with good hearts. I am still incredibly weary of police on the whole. It seems that both commissioned and elected LEO lack the right level of accountability and we would do well to curb their immunity.
Thanks for the thoughtful answer and not kneejerk snark and downvotes like I'm getting elsewhere in the thread.
I think that I agree to a large degree, but with the caveat that elected sheriffs that don't serve their communities get voted out. Incoming elected sheriffs know well why their predecessors lost their seat. In theory, but to a much lesser degree, this should also apply to commissioned LEO, but often in large municipalities there's only one pool you can pull candidates from.
This isn't perfect, but it does largely function in places with sane government/electorate. Also it kind of just follows that in such cases abuse of power (and who it is abused against) is at the direction of voters.
These abuses happen because at some level, we want them to. Just not to us.
Aside: I would like to see more departments where the boss of cops is not just an appointment by politicians, but an elected position accountable to voters and not controlled by other political office.
It's a system whose implementations don't do anything to prevent or even detect this. It's not licensed by seat, so it doesn't require SSO and when the data was available it was obvious that most departments use shared accounts. There are no laws to regulate the use of it, so they do not. It gets rushed into production via Federal grants with limited time windows.
If you have a system that isn't designed around accountability in a place like a police department, you won't get accountability, and you will get institutionalized poor behavior. It's one of the reasons that state police organizations are usually considered more "professional" or better disciplined than most local departments.
Bureaucracy and size reduces random dumbass employee use of their discretion. People look the other way less often when there is a record of malfesance right in front of them. You don't need to be "pro" or "against" police to demand accountability.
The title doesn't make that sound like that at all. Unless you think in any world there woukd be able institutional procedure to abuse systems like that. To normal people it reads like police abusing the systems they have access to.
Of course it does, it says "Police have used license plate readers..." not "Police officers have used license plate readers..." or indicated that individual officers have abused their authority.
The classic "just some bad apples" argument in defense of corruption.
In Toronto, police are pressured into gang-like conformity to support their bad apples - from last week:
> A Crown attorney is being accused of suggesting a police witness should have provided false evidence while testifying in court.
> According to the Toronto Star, a heated interaction occurred in the hallway of a Toronto courthouse earlier this year, between Crown attorney Marnie Goldenberg and Constable Edin Hasanbasic of the Toronto Police Service.
> Hasanbasic had been called as a witness in the case of a man accused of hitting a different officer with his motorcycle, with the intent of causing harm.
> Hasanbasic had just told the court that the officer who was struck by the motorcycle “seemed like he was fine” after the incident.
> Goldenberg, according to Hasanbasic’s notes about the encounter, allegedly got angry about his testimony, because it went against the Crown’s case.
> “What am I supposed to do? Lie?” Hasanbasic recalls saying.
> The attorney allegedly responded by saying, “We protect our own.”
> The classic "just some bad apples" argument in defense of corruption.
Not really, something definitely should be done to correct it but some people have this notion that throwing out the baby with the bath water is and starting over from scratch is the correct action. If anything that will just create new problems and make the ability to hide misdeeds even easier.
I’ve done a lot with Claude and OpenAI both, A LOT, but I’m still a little wary at letting it have too much access so I haven’t tried this feature in either of them.
Man, I’ve spent so many years now without google, I want to try it because I want to try different agents but I don’t really want to setup google on my MacBook.
Does this have console like Claude and codex?
---
I was able to install and use Gemini on macOS fine authentication worked. I had some issues authenticating with the cli app, some certificate issues.
Once I got past the certificate issues, now it will not let me use the cli code assist without verifying that I am 18+ but I can use the UI app just fine without the verification.
To verify, seems to require submitting a government issued ID or credit card.
No thanks. This kind of stuff is why I dropped google long ago.
At least as of about 6 weeks ago, Gemini cli was a buggy mess. I ended up hitting bugs every 30-60 minutes that required completely resetting (clearing the cache, logging out and in) and then if I resumed an old chat the bug was back.
I saw a joke on Reddit: Anthropic doesn't let you use claude with 3rd party harnesses. Google doesn't even let you use Gemini with their own harness.
Gemini cli is literally the worse agentic cli tool that I've tried and Google won't let you use your credentials with any other.
It lacks obvious features that all the others have, crashes constantly, breaks so badly you lose work at least once a week, is seldom updated, and worse was recently crippled even further intentionally.
Google has had load issues forever. Their most recent solution has been to throttle CLI users to the point that it's almost useless. The only way to get decent service is to pay per query with the API now.
I cancelled my Ultra plan and went to ChatGPT. They still let you chose your preferred tool. Meanwhile, Googles forums and github are filled with wailing and gnashing of teeth, but Google customer service policy is the same as it was when they just did search: reproachful silence.
Out of curiosity, why do you like gemini-cli better than claude or codex? And do you have any comparisons to opencode or pi?
Personally I've really liked OpenCode's TUI, but maybe on a superficial level of "this looks good and feels ergonomic to me".
Gemini cli felt clunky for me when I tried a while ago, but maybe it's better now? I do like how it's open source and I'm wondering if it can be made as model agnostic as OpenCode.
I don't really see or feel a difference in a lot of the the cli tooling, however, for development work Gemini is just hands down better. And I pay for ultra, and while that's not cheap, I know I can just use it however long I want for whatever I want and I'll never go past the price I pay unlike some API key only models.
Nice! With Anthropic and OpenAI lowering usage limits that’s a big deal. I’ve been considering a Gemini subscription because I’m already paying for the Google storage plan and it would only be $10 a month more for me.
Do you use Gemini 3.1 pro or the flash model or just auto? Any feelings about quality vs other models?
I find it amusing or maybe even confusing that the developers seem to be changing the TUI look every month or so. Sometimes I go for 2 weeks without vibing cause I am working on something that doesn't involve coding or whatever and then I open gemini-cli only to be greeted with an update and a new UI
I’ve used it to get me to the desktop where the app is open but yeah, generally you’re right. I use spotlight more often for searching the Mac and opening apps or swiping desktops
First of all, this looks really nice, I mean REALLY nice. It’s obvious you put a lot of thought and work into making the UX work really well. I probably will not use it, I like macOS as it is and have gotten used to it over the past 10+ years. I am probably not the target user though, seems like it could be good for new users transitioning from Windows.
How does this work with the dock in macOS? I mean you only have so many places you can put the dock, certainly not the top because that’s reserved for the mighty blue Apple.
Indeed. It took me a bit to remember why. There was a clemency program for nonviolent drug offenders with otherwise clean records who had served at least 10 years in federal prison under out of date sentencing guidelines.
reply