#web database

[fanfenomenon]

hyperfixated on this game so hard i tried to recreate ac syndicate's animus database using html css and js👍

i will make this responsive though, i've only started doing the frontend but i'll also start doing the backend as soon as i finish this

basically this is gonna be a website that will allow you to create a database of your assassin's creed OCs (btw this was inspired by @gwen-the-assassin's idea <33) and help you with worldbuilding and making AUs (i know the ac fanon wiki already exists for that but i wanted to make the experience of keeping a database more immersive u know....)

this might take a while to be completed, but I'll try to post updates on it as much as possible! if there are any programmers/web developers in the ac fandom that want to contribute to this project plsplspls DM me!!

actual pic of the database for comparison:

ik it's not entirely accurate but this is the simplest database in the game that i could recreate lmao

also code snippets just cuz (+ me crashing out)

[daydreamingastronauts]

whatever databases me nd my team are istalling, they are not working(even after following every step carefully) please help if you know any solution to this

[creepyscritches]

Everytime I have to discern what the fuck the doctor meant by an abbreviation, I briefly think abt the twitter users I saw at each other's throats for using BPD to mean borderline personality disorder OR bipolar disorder like the acronym would run out of uses and wonder what they'd think if they saw even one page of the Stedman's Medical Abbreviation dictionary

[database-design-tech]

The Great Data Cleanup: A Database Design Adventure

As a budding database engineer, I found myself in a situation that was both daunting and hilarious. Our company's application was running slower than a turtle in peanut butter, and no one could figure out why. That is, until I decided to take a closer look at the database design.

It all began when my boss, a stern woman with a penchant for dramatic entrances, stormed into my cubicle. "Listen up, rookie," she barked (despite the fact that I was quite experienced by this point). "The marketing team is in an uproar over the app's performance. Think you can sort this mess out?"

Challenge accepted! I cracked my knuckles, took a deep breath, and dove headfirst into the database, ready to untangle the digital spaghetti.

The schema was a sight to behold—if you were a fan of chaos, that is. Tables were crammed with redundant data, and the relationships between them made as much sense as a platypus in a tuxedo.

"Okay," I told myself, "time to unleash the power of database normalization."

First, I identified the main entities—clients, transactions, products, and so forth. Then, I dissected each entity into its basic components, ruthlessly eliminating any unnecessary duplication.

For example, the original "clients" table was a hot mess. It had fields for the client's name, address, phone number, and email, but it also inexplicably included fields for the account manager's name and contact information. Data redundancy alert!

So, I created a new "account_managers" table to store all that information, and linked the clients back to their account managers using a foreign key. Boom! Normalized.

Next, I tackled the transactions table. It was a jumble of product details, shipping info, and payment data. I split it into three distinct tables—one for the transaction header, one for the line items, and one for the shipping and payment details.

"This is starting to look promising," I thought, giving myself an imaginary high-five.

After several more rounds of table splitting and relationship building, the database was looking sleek, streamlined, and ready for action. I couldn't wait to see the results.

Sure enough, the next day, when the marketing team tested the app, it was like night and day. The pages loaded in a flash, and the users were practically singing my praises (okay, maybe not singing, but definitely less cranky).

My boss, who was not one for effusive praise, gave me a rare smile and said, "Good job, rookie. I knew you had it in you."

From that day forward, I became the go-to person for all things database-related. And you know what? I actually enjoyed the challenge. It's like solving a complex puzzle, but with a lot more coffee and SQL.

So, if you ever find yourself dealing with a sluggish app and a tangled database, don't panic. Grab a strong cup of coffee, roll up your sleeves, and dive into the normalization process. Trust me, your users (and your boss) will be eternally grateful.

Step-by-Step Guide to Database Normalization

Here's the step-by-step process I used to normalize the database and resolve the performance issues. I used an online database design tool to visualize this design. Here's what I did:

Original Clients Table:

ClientID int

ClientName varchar

ClientAddress varchar

ClientPhone varchar

ClientEmail varchar

AccountManagerName varchar

AccountManagerPhone varchar

Step 1: Separate the Account Managers information into a new table:

AccountManagers Table:

AccountManagerID int

AccountManagerName varchar

AccountManagerPhone varchar

Updated Clients Table:

ClientID int

ClientName varchar

ClientAddress varchar

ClientPhone varchar

ClientEmail varchar

AccountManagerID int

Step 2: Separate the Transactions information into a new table:

Transactions Table:

TransactionID int

ClientID int

TransactionDate date

ShippingAddress varchar

ShippingPhone varchar

PaymentMethod varchar

PaymentDetails varchar

Step 3: Separate the Transaction Line Items into a new table:

TransactionLineItems Table:

LineItemID int

TransactionID int

ProductID int

Quantity int

UnitPrice decimal

Step 4: Create a separate table for Products:

Products Table:

ProductID int

ProductName varchar

ProductDescription varchar

UnitPrice decimal

After these normalization steps, the database structure was much cleaner and more efficient. Here's how the relationships between the tables would look:

Clients --< Transactions >-- TransactionLineItems

Clients --< AccountManagers

Transactions --< Products

By separating the data into these normalized tables, we eliminated data redundancy, improved data integrity, and made the database more scalable. The application's performance should now be significantly faster, as the database can efficiently retrieve and process the data it needs.

Conclusion

After a whirlwind week of wrestling with spreadsheets and SQL queries, the database normalization project was complete. I leaned back, took a deep breath, and admired my work.

The previously chaotic mess of data had been transformed into a sleek, efficient database structure. Redundant information was a thing of the past, and the performance was snappy.

I couldn't wait to show my boss the results. As I walked into her office, she looked up with a hopeful glint in her eye.

"Well, rookie," she began, "any progress on that database issue?"

I grinned. "Absolutely. Let me show you."

I pulled up the new database schema on her screen, walking her through each step of the normalization process. Her eyes widened with every explanation.

"Incredible! I never realized database design could be so... detailed," she exclaimed.

When I finished, she leaned back, a satisfied smile spreading across her face.

"Fantastic job, rookie. I knew you were the right person for this." She paused, then added, "I think this calls for a celebratory lunch. My treat. What do you say?"

I didn't need to be asked twice. As we headed out, a wave of pride and accomplishment washed over me. It had been hard work, but the payoff was worth it. Not only had I solved a critical issue for the business, but I'd also cemented my reputation as the go-to database guru.

From that day on, whenever performance issues or data management challenges cropped up, my boss would come knocking. And you know what? I didn't mind one bit. It was the perfect opportunity to flex my normalization muscles and keep that database running smoothly.

So, if you ever find yourself in a similar situation—a sluggish app, a tangled database, and a boss breathing down your neck—remember: normalization is your ally. Embrace the challenge, dive into the data, and watch your application transform into a lean, mean, performance-boosting machine.

And don't forget to ask your boss out for lunch. You've earned it!

[uniquesdata]

Unlock the Power of Data with Uniquesdata's Data Scraping Services!

In today’s data-driven world, timely and accurate information is key to gaining a competitive edge. 🌐

At Uniquesdata, our Data Scraping Services provide businesses with structured, real-time data extracted from various online sources. Whether you're looking to enhance your e-commerce insights, analyze competitors, or improve decision-making processes, we've got you covered!

💼 With expertise across industries such as e-commerce, finance, real estate, and more, our tailored solutions make data accessible and actionable.

📈 Let’s connect and explore how our data scraping services can drive value for your business.

[bf-rally]

outline of the logo! i decided to use one of my ocs on the side

[angelfrommontgomery]

I forget how different scientists and engineers are. What do you mean you want to meet on zoom for thirty minutes to talk at a high level. I want to look at four numbers for three hours in an office together

[shirohirolu]

I finally gave my gworl a reference sheet ayyeeee

Took me forever to actually give her an outfit but ye here she be in all her glory, I’ll update later with the rest of the info I couldn’t fit on the sheet lol

[howlingaround]

If I had a nickel for every time the higher dimensional antagonists of a high concept sci fi story are ambigously described as Giant Invisible spiders, I would have two nickels

Which isnt a lot but its weird how it happened twice

[borealing]

"learn to code" as advice is such bullshit. i have learned and used four and a half different coding languages through my career (html/css, java, python+sql, c++) and when i say used i mean I've built things in every one but the things that i actually used these languages for??? these earn zero money (with the caveat of until you have seniority in, e.g. front end web dev) what people really mean when they say learn coding is "learn to code. go into investment banking or finance startups." coding does not inherently have money in it. my absolute favourite part of coding? my peak enjoyment? was when i was developing for a visual coding language (you put it together like a flowchart, so say youre using a temperature sensor and you want it to log the temperature once every four hours, you can put the blocks together to make it do that. i was writing the code behind the blocks for new sensors) and i was earning £24k a year and that wasn't even part of my main role. it was an extra voluntary thing i was doing (i was working as a research assistant in biosensors - sort of - at a university, and was developing the visual code for students who didnt want to learn c++) like. i want people to learn to code, i want people to know how their electrical equipment works and how coding works, but dont believe the myth that there is inherently money in coding. the valuable things, the things people are passionate about are still vulnerable to the passion tax (if you want to do it you dont have to be paid for it). skills arent where the money is, money is where the money is.

[l-stanny]

Angular SPA integrated with the Spotify Web API returns JSON metadata about music artists, albums, and tracks, directly from the Spotify Data Catalogue.

[tornadodyke]

I hope you did okay on your test. I remember being in a college math class and feeling the same after walking out of a test, and I ended up getting a C or something. I hope you pass, and even if you don’t, it’s not the end of the world, I promise (even if it feels like it. I have also been there.) 🧁 🍪 💖 <- for you!

THANK YOU I APPRECIATE IT......god it's just. i wish the class had more homework to be graded on. we get one quiz once a week and the quizzes themselves are only worth 16% of our grade total and then we have 3 tests all worth 28% of our grade and that's it. so if you fuck up on the tests your whole grade is screwed. and i was keeping track of the questions i thought i missed vs the questions i thought i got right and my guesstimation is that i made somewhere around a 60 or so. which is enough to screw me over. and i just. sighhhhhh

[ofdreamsanddoodles]

also everyone look at piguel o'malley

[uniquesdata]

Insights into Web Scraping Services and Process to Extract Content

Web scraping services have become indispensable tools for businesses from various sectors that help in gaining valuable insights and also helps in gaining competitive edge in the market. Understanding in detail about web scraping services and business can leverage it.

[imarketer4udma-blog]

7 MOST POPULAR TYPES OF WEBSITES AND WHAT THEY INCLUDE

According to research, 38% of people will stop interacting if a website is poorly designed. This means that you should make sure that your website layout sends the right message and answers all your target audience’s questions. 

There are several types of websites that you can go for if you want to establish and improve your online presence in the market. Each one of them is designed to satisfy a specific purpose. So, which one should you go for? How can the right website design and layout help your business boom?

This article will explain the 7 most popular types of websites, their purposes, and features. Keep reading to learn more about them.

7 MOST POPULAR TYPES OF WEBSITES

There are currently more than 1 billion websites on the internet, and the number increases all the time. Some of them are definitely more successful than others, so it’s essential to pick the right website design for your business. 

Today, web development has become easier, so you can just log into a free website builder and have a functioning website. However, this doesn’t mean that you’ll be able to use the website to elevate your online presence. 

You should ask yourself questions like what should my website tell my target audience? How can I use my website design and layout to send a message to my prospects? 

Each type of website has specific features and purposes. We’ll discuss the most popular ones in this section.

1. Business Website

Purpose

Tell your target audience why they should work with you

Features

List of products and services

An About Page to tell the customers about your company

Contact information

A call to action

This is one of the most common website types. The company will share examples of past work and customer feedback and explain how to make an order or contact for more questions. In this type, visual branding is crucial, as the website layout should tell your target audience what your brand is all about. The design should be simple to answer as many questions as possible, making sure that the logo and typography complement the company’s message. Customers should be able to get the information they need without scrolling various pages.

2. eCommerce Website

Purpose

Sell online products and services

Features

High-quality images that show the products and services

Easy to navigate with clear sections

Details about your business, shipment, returns, and refunds should be clearly listed

Secure checkout and transactions

eCommerce websites are quite popular because the company sets up a website to sell its products and services online. Once you have an eCommerce website, you’ll have a functioning online shop that you can use with the physical store to increase your sales. 

There should be a section for customer service and an About Us section that tells your potential customers more about your business. Just like a business website, sticking to a consistent visual branding strategy is extremely important. Moreover, it should be simple so it doesn’t confuse users. 

3. Blog/News Website

Purpose

Provide valuable information about the industry or company

Features

Article lists

Tags for easy navigation

Updated posts

Can lead to an online store

Messages section for more information

The blog or news website should be related to your company’s niche and market, and it should be updated regularly with new posts or the latest news in your industry. The purpose of this website is to deliver valuable content that your target customers will appreciate. Think of what your target customers ask about, how to use your product, and what other products they can use to have a better experience. All these topics can provide excellent content for your blog.

4. Portfolio Website

Purpose

Display samples of work to attract customers

Features

High-quality images

Work samples

Contact information

Creating a portfolio website involves listing information about past projects to promote someone’s business. It can be used by individuals, especially those who work in a creative field, or by agencies and companies. This type of website can lead to an online shop or just display the contact information that customers need to get to the physical store or to contact the website’s owner. 

It should be easy to navigate and needs consistent updates. Your target audience should see that you’re engaging in successful projects to consider you for an upcoming one. 

5. Service Provider Website

Purpose

Offer an online service

Features

Easy to use

Payment options for subscriptions

This website will work for you if you offer an online service, like converting files to other types, a photo editor, or a grammar checker. The website should be easy to understand, and visitors should be able to access the tool instantly. In most cases, you can offer a limited version of your service that users can try for free. After that, they should be able to pay a subscription to access the tool’s full potential.

6. Landing Page

Purpose

The main part of a marketing campaign that leads to other pages where customers can learn more about your brand

Features

A single call to action

A brief description of the products and services

A clear visual brand

The landing page is a one-page website that your target audience reaches when they click the company’s link. Therefore, the website’s design should stick to the brand’s visual identity and should be simple and to the point. The landing page should work for lead generation, so customers can download an online catalog or learn more about the company’s products through a newsletter.

7. Wiki/Database Website

Purpose

A reference or index that provides a lot of information

Features

Easy search functions

Lots of linked pages

Ability to add comments or edit

This website serves as an index that shows a lot of information. When your target audience clicks any link, they’ll get transferred to another page that shows detailed information about your products or services. A database website can also be accessible to users who can contribute to the added content.

LET THE EXPERTS HELP

Are you wondering about how to build a website that serves your business purpose? Let our experts help you build the one that will improve your online presence and attract the right audience. A successful website starts with a successful web design, so click here to get yours today. 

[panpteryx]

hey so I work in the supplements industry (as a database admin not sales) and this? 100% accurate

the people working with it are not comprehensively trained and some of them seem to barely have a highschool understanding of chemistry/biology: I met a guy who while ostensibly "fully trained" to give people recommendations on herbal supplements (ie. semi-unregulated (I'm in Canada so there are some regulations) compounds that can significantly impact your health if not taken with the utmost care, re above) didn't know what a damn polysaccharide was. or that dietary fibre is largely just indigestible cellulose which is sugar and different sugars digest differently.

but past the lack of information or actual training the thing that bugs me the most is how the entire industry is fully blurred between stuff that IS medically relatively sound and stuff that isn't

Like. vitamins and minerals get lumped into "complimentary" medicine a lot of the time and those largely (not always) DO have genuinely useful and medically studied effects and effectively measured doses! iron and vitamins b12 and C deficiencies can in fact be treated with supplements. whether vitamin D and magnesium do much as a supplement is a bit more iffy research-wise but there's some decent work looking at magnesium to help with migraines and stuff and I can say it does actually seem to do something for me.

HOWEVER. you put those on a shelf next to fucking. homeopathic "holy basil" and St. John's wort pills and garlic pills and it just muddles the entire damn thing. actually studied vitamins and minerals next to a damn 50$ vial of water with the same amount of active ingredient as it would if someone waved a leaf over and the medieval "will kill a fetus before it kills you probably if you're lucky" abortion pills I don't hate this shit because it doesn't work: I hate it because it's extremely unpredictable and you can't predict when it'll work. And it will!

and the issue with that is people treat it so lightly. like. even if we're assuming that the compounds in these herbals are being isolated and dosed effectively and there are no unlabelled add-ins (which is a hard assumption but for the sake of the argument) people treat it like it's "just herbs" instead of (ostensibly) medicine. if doctors should not be telling everyone "eh just take this strong gallbladder medication for a month or two, see if it does anything" without comprehensive testing to see if the patient actually has a gallbladder issue, why the *fuck* are these "natural health advisors" doing that with what's supposed to be the equivalent in herbals?

for a lesser example of people taking things very lightly: it's happened at least twice but I just remember this occasion where a coworker from the sales floor came back to the office with an innocuous looking bottled drink like "hey these just expired you want one": I grabbed an ice tea, took a swig, and then ten minutes later I was flat on my desk struggling to keep my eyes open because AS IT TURNS OUT the drink was laced with ashwaghanda. which is a stimulant. which makes me exhausted (same as coffee).

this wasn't entirely unpredictable: I've got adhd and respond atypically to a lot of stimulants and stuff. Guess what a lot of "helps you focus and makes your brain work better" supplements are? Yeah.

This is a pretty mild example of a bad side effect ("annoyingly tired at work for a day") but. you don't just dose people with stimulants without telling them they're stimulants! those drinks were just up by the counter in a cooler labeled as ice tea! they didn't have any caffeine in them so they weren't labeled as having caffeine: people don't know what ashwaghanda is! what if someone had heart problems! my "ugh why am I so tired" response to stimulants is extremely minor by comparison to the problems someone with other conditions might have!

--yeah. it's fucked. don't take anything if you haven't done comprehensive research on it and you know (and it's POSSIBLE to know) exactly what and how much of what is in it. and especially don't give it or suggest it to other people.

When you say you're anti-CAM what does that mean? Like what does CAM mean in that context? I genuinely haven't seen that acronym before and I'm assuming you aren't anti-camming as in like the form of sex work

Complimentary and Alternative Medicine.

I am capable of turning off my inner annoying atheist, I am incapable of turning off my inner annoying quackwatcher.

I have had real life fights with people I genuinely love about this and I do not regret it. I will absolutely not regret shitting all over someone's $500 herbalist certification.