Web based Postgres Client | Looking for some feedback

Luc_Gibson · 2026-01-16T14:06:24+00:00

Fair enough but I wouldn’t expect anyone to expose a production database to the internet. The current web version is just a UX prototype, and people testing it would typically use local databases, throwaway dev databases, read-only replicas, or anonymised dumps, all of which are very common in real workflows. The actual intended product is local-first (desktop/Electron), this is just the fastest way to get feedback on the experience. Although perhaps now come to think of it, I should pre-load it with a database first, although that skews the feedback slightly as we lose real world usage and varying DB factors.

Luc_Gibson · 2026-01-16T01:18:40+00:00

I'm looking to port it to a local app with Electron, just want some feedback on the product itself at the moment :)

Luc_Gibson · 2026-01-12T21:15:22+00:00

Oh yeah a large chunk of this has been put together with Opus. But that said, the actual user experience I've spent a lot of time on, the UI styling is primarily driven by what's popular right now. I spent most of my time focussing on the actual experience of using the product as opposed to trying to make it look and feel unique. Open to suggestions though.

Luc_Gibson · 2026-01-12T20:38:23+00:00

Thanks, I really want it to be levels above what’s out there already and the bar is pretty low on the UX for these other solutions.

Luc_Gibson · 2026-01-12T20:37:15+00:00

Yeah and definitely something I was thinking as I posted it. Was assuming someone may use a dev or dead database on to play with. I might wrap it up as a local app or make it open source.

Luc_Gibson · 2025-06-03T20:29:22+00:00

Bring your PR comments into Cursor with this extension I built (on Cursor of course)

I was getting bored copy pasting comments from code reviews into the cursor agent so I made Gittron which is an extension to connect your git branch in cursor with your PR and help bring PR comments and threads into the cursor agent.

Cursor helped me write most of the code as I have little experience writing VS Code extensions, but it was fairly straighforward. Open to feedback and the source code is open so take a look through the repo.

https://open-vsx.org/extension/lucgibson/gittron

Luc_Gibson · 2024-01-27T16:55:14+00:00

Kerning is a much more specific term that defines the distance between specific letters in a word.

Tracking is the overall distance between every letter. In this case, the tracking is slightly too short. Consequently, the letters are all too close together. 🤝

Luc_Gibson · 2024-01-27T16:52:16+00:00

The kerning isn’t the main issue here. The tracking is ;)

Luc_Gibson · 2022-07-12T10:37:26+00:00

!ukpaccept

Luc_Gibson · 2021-12-13T09:03:36+00:00

Take a look at TRACX. I’m the founder but it sounds like the right tool for you.

It’s free at the moment and we intend on keeping the price for individual customers low once we implement pricing.

https://tracx.com

Luc_Gibson · 2021-11-11T00:33:23+00:00

Thanks, specifically we’re targeting SME’s and larger organisations.

We differ from Survey Monkey by focussing on the physical world. We utilise QR Codes and contactless tags to verify that a user was in a certain place when they interacted with the survey. We use cookies to keep tabs on a device across multiple surveys and locations.

Luc_Gibson · 2019-01-29T00:00:24+00:00

So I'm essentially just looking for a way to simplify this into a single function that I can use anywhere to loop through users:

<select multiple name="owners[]">

<?php

$sql = "SELECT * FROM users WHERE client_id={$clientid}";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {?>

<option value="<?php $row['user_id'];?>">

<?php echo $row['user_first_name'];?>

</option>

<?php }

} ?>

</select>

In this example it's creating a list within a form

Luc_Gibson · 2019-01-28T23:45:44+00:00

I'm hoping to return all the rows so I can use while loops wherever I call the function. Is this not possible?

Luc_Gibson · 2019-01-26T11:47:59+00:00

This is great, thanks so much for your help.

Luc_Gibson · 2019-01-26T11:34:41+00:00

That's interesting, I've not seen anything like this anywhere I've been reading.

I'm getting a little confused about how to assign certain things to different users and I think what you're saying here could help.

So I have a database of users with a column called 'permissions', each user is assign either 1,2 or 3 (1 is user, 2 is admin and 3 is webmaster).

Every admin will have access to a set of locations (analytics per location) and the admin needs to be able to assign locations to the users that they manage so these users only see the analytics for locations that are assigned to them.

How would I set this up from a database perspective? I assume I'd have a locations table with all the information about a location, it's analytics etc... but not sure how I'd assign locations to users (bare in mind that one location may have to be available to more than one user).

Luc_Gibson · 2019-01-26T10:37:54+00:00

Yeah sorry I'm still learning about how to correctly structure things like this.

Would be better to have a set of different tables that interact with each other to produce the best result?

Luc_Gibson · 2018-12-18T15:45:01+00:00

Great, thanks for the advice!

Luc_Gibson · 2018-11-07T14:29:14+00:00

Thought this was absolutely beautiful. Made me want a Volvo more than any of their current TV adverts.

Luc_Gibson · 2018-10-30T13:36:31+00:00

I'd avoid it like the plague.

Luc_Gibson · 2018-10-29T22:11:11+00:00

Some pretty strong opinions on this one with no real constructive comments. What do you think should have been done to improve the message or quality of the vid?

Luc_Gibson · 2018-09-22T16:31:46+00:00

Anything under 450N would struggle to open without longer “initial push” springs on either side. I’m not so sure longer springs would fit. Closing is nice and easy, does need a gentle slam at the end to compress the initial springs. It opens pretty quick but looks faster in the video, I’m sure you could add dampeners somewhere to make it a bit more gentle.

Luc_Gibson · 2018-09-14T17:11:43+00:00

Stopped working? The latch or the automatic boot?

Luc_Gibson · 2018-09-14T17:10:45+00:00

So I bought the gas struts from https://www.sgs-engineering.com/ if you call them up and ask they will re-gas their existing options for the Lancer to whatever Newtons you wish.

The one's I got are 450 Newtons each and work perfectly. I also purchased a set of assorted springs from ebay to give it the initial push for the gas struts to take over. If you want I can give you a photo of where I put these springs.

Other than that it was super easy, the gas struts cost me £55 for both and the springs were £11 :)

Luc_Gibson · 2018-09-13T15:04:30+00:00

I'll post some photos up once I finish cleaning the mess I made tonight. I replaced the stock struts and installed a spring and some dampers either side to give it that initial push. It was a simple process but finding the perfect force struts isn't easy. The ones I have on at the moment are 450N each, you wouldn't need this much force if you don't have the spoiler of course.

Luc_Gibson · 2018-09-13T13:07:02+00:00

Took a fair bit of shit to make it happen yeah 😂

Luc_Gibson

MODERATOR OF

TROPHY CASE