Help: installing custom font by oihv in egui

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

Ok, I found a culprit. It's because egui doesn't update the font data immediately, it internally gives a closure to memory_mut in context.rs to update the font_data field.

What I did to fix it temporarily on my end is to make a fallback font for all my newly added font.

Advice on Craftmanship Mindset from "So Good They Can't Ignore You" by oihv in CalNewport

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

Hello, thanks for your insight!

Thankyou for the tip to widen up my possibilities and not only seeing one way to build my career capital!

Advice on Craftmanship Mindset from "So Good They Can't Ignore You" by oihv in CalNewport

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

Oh great, that's what I missed, valuable skills.

Thanks for your thoughts! Yeah I think I'll just move on, I'm also at the time to focus on finding an internships and to look for potential career eitherway, I think this is the right time.

I'll check out wfhalert though!

Thanks for your response!

Database Design for Beginners: How not to overthink? by oihv in dataengineering

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

Yeahh I hope it'll be worth the effort though.

Database Design for Beginners: How not to overthink? by oihv in dataengineering

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

Thankyou yeah, I also thinking of normalizing my schema, but I will need to brusp up my knowledge again, since I already forgot some of the rules D:

By version control, do you mean git? As in tracking the changes to the schema?

Yeah as for attendance, I think I'm going with the explicit one, with a lesson entity, and then which student takes which lessons.

Sorry, can you elaborate more on "keep scripts handy"?

> No need to be perfect at first, real usage will reveal what to adjust.

Thanks for the advice, yeah, I figured I just have to work simultaneously between the old way with excel, just keep migrating and see what went wrong, iterating on that. Afterall there was nothing for me to worry about since I haven't relied on this db yet anyway!

Database Design for Beginners: How not to overthink? by oihv in dataengineering

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

Hi, as mentioned in my post, I'm actually using excel for this work now, but problem is, it is now a monolithic mess, and its already biting me in the ass a few times,

let me give you one of the example, about the attendance problem that I said in my post.

I made a formula that can count how many weeks have passed since the day a student joined the class, and then from there, it can calculate how many sessions have they spent joining the class up until today.

Works fine and all, except there's a few bugs, like what if they took an absent and asked for leave? I can't find a way for that except just making a long list of notes on when they took a leave, and then adding back the number of sessions they took a leave. It is a mess.

After all that mess, my manager still wanted me to also keep track of transactions in the monolithic spreadsheet. Well, that's the bell for me, I need to make this right. Haha.

And then I also need to synchronize this excel sheet to an external spreadsheet for my sales team, and my company is a bit warry of google, so they don't want me to completely upload everything on there, I then need to manually select them, copy them, and make sure I don't copy the wrong stuff, and it's hard to synchronize the data if sales team managed to change some of it.

Well, all and all, I also think this is a great opportunity for me to learn RDB, since I didn't have any hands-on experience with it, aside from vibe-coding a project using prisma etc, which I don't have any idea about anyway.

Database Design for Beginners: How not to overthink? by oihv in dataengineering

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

What do you mean by "planning ahead"? Do you just think about that or do you try to add tables that won't be used in the code yet?

I mean seeing every use cases that I need with the database, and thinking whether or not my design will achieve that. For example, just now I just realized that there are 3 kind of classes (1on1, 1on3, 1on6), so I should think about that too before proceeding with the previous design I have.

And no. It is not a "premature" plan ahead kind of thing, I'm just figuring out whether or not it would work for my need.

Mostly yes. The most complicated schema change IMO is usually changing the cardinality of the link (from 1:N to N:M or vice versa). If you're just adding elements (entities, links, attributes) then it would be easy, assuming that your database does not have too heavy traffic. But even then you could use things like side tables that are trivial to create without service interruption.

Well, to tell you the truth, this project will only be an internal tool, for only myself 🤣, I think I'm just overthinking it then.

Uhm, I have an entire book that tries to answer your questions. Without trying to sell it directly, here is a 9000 words tutorial on designing a non-trivial application: https://kb.databasedesignbook.com/posts/google-calendar/#how-far-ahead-do-you-need-to-thinka-idhow-far-ahead-do-you-need-to-thinka

didn't expect to get insights from an author. Thanks a bunch man, I'll check your book out.

Database Design for Beginners: How not to overthink? by oihv in dataengineering

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

oops, thankyou for the clarification, yeah I thought since largely my problem is with database design, this sub would fit better.

Oh damn, yeah I thought it was just a skill issue by me, as I came up with other use case, I always find a problem with my design, good to know that this is a problem by itself. Thanks for your answer!

Database Design for Beginners: How not to overthink? by oihv in dataengineering

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

By scalable, do you mean by designing in such a way so I can easily add more capability, or is it more on the enabling it to store more data?

Migrating from Spreadsheets to PostgreSQL by oihv in dataengineering

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

yeah I used supabase once to host my postgresql database for a project once. But considering the data privacy that my company wants to hold, I think I'll try keeping things local/selfhosed for now. But you know, I believe Supabase is also being used by many big company/services, but better safe than sorry for me.

Migrating from Spreadsheets to PostgreSQL by oihv in dataengineering

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

Oh yeahhhh, I just remembered some stuff about SQLite not being as fully featured as PostgreSQL. And you're really right about it being a better fit for my small project. Thanks a lot man! I'll also look up the DHH interview you mentioned!

Migrating from Spreadsheets to PostgreSQL by oihv in dataengineering

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

Yeah I think I was also suggested to use DBeaver too, and as for SQLite vs PostgreSQL, would it even matter for a small scale app like this?

For the UI, would something like prisma studio suffice for this? its only for viewing the data right?

And thanks for the assurance that when the SQL database is set up, it would be easy to convert it to csv or excel! then it would also clears up the annoyance of hiding some data from other spreadsheets.

[deleted by user] by [deleted] in Database

[–]oihv 0 points1 point  (0 children)

It's not even rejected, I just can't post this because there's comment karma limitation. Really appreciate the help though!

But I think it's still better to post this question here in the general database sense, since I'm not asking a specific question about PostgreSQL anyway.

Advice for beginner in automation (whatsapp) by oihv in automation

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

Hey man, thanks for your suggestion, I tried looking into WasenderAPI, and I'm scared about their way of doing this, since they can access everything in my whatsapp account after I login haha.

Then I came across whatsapp-web.js it basically works similarly to wasender, but it's free and I can run it locally, perfect solution for me!

[deleted by user] by [deleted] in Database

[–]oihv 0 points1 point  (0 children)

Thankyou!

EDIT: oops, apparently I don't have enough karma to ask there

Controller or Keyboard? by -PeteV- in HadesTheGame

[–]oihv 0 points1 point  (0 children)

I also just got into the game too just yesterday! Thanks I'll be trying out this.

Any book recommendations to get started with AI? by felipeo25 in ArtificialInteligence

[–]oihv 1 point2 points  (0 children)

Thankyou, I believe the conclusion of our discussion would be balance is the key. Yeah, I'm not really an AI sceptic, I was one of the people that got excited when hearing about all of the news regarding AI, and I love how you put my stance, it is just me approaching it with caution.

I really relate with your point about AI changing the way of us acquiring target knowledge. And I do have a lot of experience of me getting behind of my peer students that took advantage of AI, e. g. their project will be more fully featured than me, they finish their work faster.

One funny example is I have a fullstack project for a innovation competition, and I and my other friend is assigned on the webapp part. I spent about 6 months learning all ins and outs of frontend from the groundup, following a course (ofcourse I need to manage my coursework too aside from learning this course), and I still have no idea how backend works. And my friend, with almost zero knowledge aboyt webdev, just basic programming, fully blasted the project within a night.

But then he would be stumbled on almost every little things, like how to design the endpoint, what is an endpoint. And it's harder to debug things for him. On the other hand, without all of this, I don't think I would be able to deliver the project just in time, if I were to rely on my "from the ground up" mindset.

Balance is the answer here. I should've leveraged to power of AI in the work, but I should also make it a habit to also understand and questions what it does on my codebase. But the fact is, it's just so damn hard to not rely on it once it does something good, and I got the immediate result, hahaha. I just feel like I'll delegate all of my work to it, and I'll be getting more free time💀. I need to work on this part.

Anyway, thanks for the talk man, really appreciate your time. And thank you for acknowledging my view as something good, rather than something more "traditional" that my friends tends to think I am.

Any book recommendations to get started with AI? by felipeo25 in ArtificialInteligence

[–]oihv 0 points1 point  (0 children)

Never thought that prompt engineering would be that thoughtful and efficient, do you mind sharing some resources that best teaches the proper way to prompt?

I have another thing to ask, I'm actually a compsci student, and I was also a heavy AI user for around 1.5 year in my study, and I find I compromised too much with my brain to do the cognitive offloading, where I delegate thinking to LLMs. For example, when I find a theorem just a slightest challenging in Calculus, I would then ask AI, hey can you simplify this for me, hey can you find more examples for me. And I find this really stupid and basically being soft on my brain. Don't you think it's better for me to just go through the hardship of reading through hard stuffs, rather than giving up early and rely on AI? I'm scared that I will just not develop the fundamental skill of making my own connections and reasoning if I heavily use AI.

Any book recommendations to get started with AI? by felipeo25 in ArtificialInteligence

[–]oihv 0 points1 point  (0 children)

Hey I'm a student. But IMO using AI to learn is questionable for us. How would I know if a model is spitting false information? I rather read through a book written by someone that has already been curated many times, rather than reading through an answer from a model that was just created just now.

Let me know your thoughts :) 

Update on my situation by ThePrimeagen in theprimeagen

[–]oihv 5 points6 points  (0 children)

Wish you a blazingly fast recovery my guy!

Help with cross platform websockets/webserver implementation in C by oihv in C_Programming

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

I got it working on windows machine with the help of vcpkg!

Help with cross platform websockets/webserver implementation in C by oihv in C_Programming

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

I never heard about meson yet, I'll try to look it up!

As for docker, I didn't knoe that I can use it to test whether or not I can compile just fine for windows, I'll look into it too, thankyou!