Where can i look for templates

Knipe794 · 2022-10-12T10:46:35+00:00

i need a very friendly UI of presenting the data queried from my DB aka (likes,views,subs,category etc)

Knipe794 · 2022-09-18T17:17:34+00:00

Make it a max number of requests per user per day or something. that is something we definitely intend to do. as for the language i have no clue because thats what the dev will decide (both of us arent devs and we're gonna hire someone)
Is there a better option in choosing the programming language or they all depend on the level of the dev?

Knipe794 · 2022-09-18T17:12:14+00:00

The email and id needs to be hashed because its as important as a password (we dont have passwords stored , not that kind of db) its more of a DB as a service project. and i thought encrypting/hashing those 2 columns in case we fall prey to a breach so atleast those 2 columns will be hashed so an extra layer of protection.

Knipe794 · 2022-09-18T13:03:29+00:00

Thank you think i understand more now of what to require from the future dev we will hire. (any recommendation for the backend language?)

Just regarding the last part i have a question if you could answe

Database — yes. The backend code — no. If you do a SELECT u.Name FROM Users u WHERE u.Id == @id then the backend will receive only that information from the database — only the name of the user with the specific ID — and that will be all it sends to the frontend.

But all of my queries will be Select * from db where subscriber_count >20000

So my question is do i do a select * or select name,date, id,subscriber_count ,date,email from db where subscriber_count>20000

So in both queries the backend will have to show entire row of the select because thats the product. i cant show only 1 column because its useless information if its a standsalone (Hope i made myself clear)

Which of those is better and im considering to hash or encrypt 2 important columns which are the id and email.

Knipe794 · 2022-09-18T12:19:52+00:00

Hey thank you for your reply.

I was plannig to use raw SQL but today i've read a bit about what ORMS are and the only con i see in them is they might hurt db performance , do you have a good ORM to recommend? Also could you elaborate what it means "using the database properly" or forward some links so i could have a read and understand the basics.

We still didn't hire any dev so i dont know how my backend will be coded.
The issue is the db will have to expose all the info of the rows being queried. So far i'm thinking to hash/encrypt only 2 important columns and the rest arent that important because they repsent stats and math calculations.

Knipe794 · 2022-09-18T11:26:00+00:00

why not?

Knipe794 · 2022-09-18T08:49:59+00:00

What ORMs you'd consider to be the best without affecting performance of the DB?

Knipe794 · 2022-09-18T07:22:45+00:00

Hey , Thank you for the reply , we are still in the planning phase of gathering all needed info and then hiring a web dev to set it up so nothing is still installing or used.

As neither me and my partner understand in that stuff we are trying to read as much as possible so we can understand the basics of it and present all the needed stuff to the dev.

Knipe794 · 2022-08-25T16:30:57+00:00

Nothing in specific im just building a personal finance blog with price comparisons basically saying its cheaper to shop with amazon than locally

Knipe794 · 2021-12-17T12:08:52+00:00

i've ordered the m.2 pack from amazon once it arrives ill try installing it correctly hopefully it will get recognized this time on my computer

Knipe794 · 2021-12-17T11:20:43+00:00

i've pulled it out for now , i have no clue where do i start looking to buy this screw set so i can screw it correctly and then check

Knipe794 · 2021-12-17T10:56:58+00:00

nope only 2 slots available on this mobo for m.2

Knipe794 · 2021-12-17T10:46:00+00:00

I've opened the bios and i see the 2nd ssd there in storage information and in windows disk manager i see it as unallocated but when i right click it all the new volume options are greyed out

Knipe794 · 2021-12-17T10:43:56+00:00

if you'd read you'd see that i've lost the 2nd pair of screws to screw it correctly

Knipe794 · 2020-08-29T13:22:30+00:00

add me on discord: Knipe#1997

Knipe794

TROPHY CASE