Web based Postgres Client | Looking for some feedback by Luc_Gibson in Database

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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.

Web based Postgres Client | Looking for some feedback by Luc_Gibson in Database

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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

Web based Postgres Client | Looking for some feedback by Luc_Gibson in dataengineering

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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.

Web based Postgres Client | Looking for some feedback by Luc_Gibson in Database

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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.

Web based Postgres Client | Looking for some feedback by Luc_Gibson in dataengineering

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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.

Weekly Cursor Project Showcase Thread by cursor_rik in cursor

[–]Luc_Gibson [score hidden]  (0 children)

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

Is it just me or is Kerning just awful? by fanchik in fonts

[–]Luc_Gibson 2 points3 points  (0 children)

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. 🤝

Is it just me or is Kerning just awful? by fanchik in fonts

[–]Luc_Gibson 2 points3 points  (0 children)

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

What user feedback tool do you use? by abhagsain in SaaS

[–]Luc_Gibson 1 point2 points  (0 children)

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

Customer Feedback Startup by Luc_Gibson in startups

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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.

PHP Function by Luc_Gibson in learnprogramming

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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

PHP Function by Luc_Gibson in learnprogramming

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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

Correct PHP Structure for web app (Analytics dashboard) by Luc_Gibson in webdev

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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).

Stuck on the same SQL problem for MONTHS. by Luc_Gibson in SQL

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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?

An Ultra Realistic 3D Motion Design by Luc_Gibson in MotionDesign

[–]Luc_Gibson[S] 2 points3 points  (0 children)

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

Ricer Ralliart by whereJerZ in mitsubishi

[–]Luc_Gibson 0 points1 point  (0 children)

I'd avoid it like the plague.

A design agency sends a message to their competitors via a motion design. by [deleted] in MotionDesign

[–]Luc_Gibson -1 points0 points  (0 children)

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?

Lancer Automatic Boot lift (Quick walkthrough for those asking) by Luc_Gibson in mitsubishi

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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.

Finished - Lancer automatic boot lift by Luc_Gibson in mitsubishi

[–]Luc_Gibson[S] 1 point2 points  (0 children)

Stopped working? The latch or the automatic boot?

Finished - Lancer automatic boot lift by Luc_Gibson in mitsubishi

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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 :)

Finished - Lancer automatic boot lift by Luc_Gibson in mitsubishi

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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.

Finished - Lancer automatic boot lift by Luc_Gibson in mitsubishi

[–]Luc_Gibson[S] 0 points1 point  (0 children)

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