SQL/Database/Spreadsheet GURUS HELP - $$$$

[Motife43]

So I've been procrastinating on a public project I'm releasing and I need some help or someone to point me to a good online database software. I want to embed this database into a website

I have all my data (1100+ rows and growing) in an excel spreadsheet with the various column headers. This is data I want to share publicly but I want everything to be in an interactive and user friendly format. A lot of the names are repeated in multiple rows and whatnot. I'm being vague but I'm hoping it's enough info to point me in the right direction.

I need the user to be able to:

• Type to search (ex. if I type Motife43, I want all the rows with data pertaining to Motife to populate)
• view 75-100 results (rows) at a time on one page
  
• Sort by clicking a column header
  
• Have the capability to hover over a name with an asterisk and read a note (i.e. Motife43* - the asterisk reflects shelved album)
• Predictive search text (typing Mot should populate Motife43 as an option and filter/display as you type)

Please help Coli fam! And if you're the breh(rette) who can build something like this, let me know.
I'll pay fa it (Soulja Slim voice)

 

[Jekyll]

I don’t know your skillset but the ELK stack would do most of what you’re looking for. Alot of sites/apps use it for full-text search. You probably wouldn’t need Kibana but you can ingest and filter with Logstash or filebeats and search with ElasticSearch.

I would be down to help but I don’t have the time.

 

[Motife43]

I don’t know your skillset but the ELK stack would do most of what you’re looking for. Alot of sites/apps use it for full-text search. You probably wouldn’t need Kibana but you can ingest and filter with Logstash or filebeats and search with ElasticSearch.

I would be down to help but I don’t have the time.

Thanks I'll read up on it.

I see a lot of these are requiring monthly hosting plans. Do yall think that type of investment will be required with what I'm trying to do? (based on my description)

 

[Jekyll]

Thanks I'll read up on it.

I see a lot of these are requiring monthly hosting plans. Do yall think that type of investment will be required with what I'm trying to do? (based on my description)

ELK has free versions. You just install with a package manager or you can run it in docker/kubernetes. You would have to have somewhere to host it though. Maybe your website host? Otherwise it’s pretty easy to get setup in AWS or Azure. You could maybe do this in the free tier

 

[AsTheWorldBurns]

So I've been procrastinating on a public project I'm releasing and I need some help or someone to point me to a good online database software. I want to embed this database into a website

I have all my data (1100+ rows and growing) in an excel spreadsheet with the various column headers. This is data I want to share publicly but I want everything to be in an interactive and user friendly format. A lot of the names are repeated in multiple rows and whatnot. I'm being vague but I'm hoping it's enough info to point me in the right direction.

I need the user to be able to:

• Type to search (ex. if I type Motife43, I want all the rows with data pertaining to Motife to populate)
• view 75-100 results (rows) at a time on one page
  
• Sort by clicking a column header
  
• Have the capability to hover over a name with an asterisk and read a note (i.e. Motife43* - the asterisk reflects shelved album)
• Predictive search text (typing Mot should populate Motife43 as an option and filter/display as you type)

Please help Coli fam! And if you're the breh(rette) who can build something like this, let me know.
I'll pay fa it (Soulja Slim voice)

Are you making the website from scratch. We use Confluence at work, which is owned by Atlassian, and it has tools to turn excel data sets into embedded searchable forms.

 

[Pyrexcup]

you could hire developers off upwork but you need to make sure you know your shyt as well because there are tons of shyt ones on there

 

[Motife43]

ELK has free versions. You just install with a package manager or you can run it in docker/kubernetes. You would have to have somewhere to host it though. Maybe your website host? Otherwise it’s pretty easy to get setup in AWS or Azure. You could maybe do this in the free tier

This is like reading a foreign language lol

Are you making the website from scratch. We use Confluence at work, which is owned by Atlassian, and it has tools to turn excel data sets into embedded searchable forms.

Nope. I've had my blog and domain name parked on Squarespace the past few years I so I'll run it from there. I guess I should look into what I can install on there

you could hire developers off upwork but you need to make sure you know your shyt as well because there are tons of shyt ones on there

I don't know anything fam. That's why I'm coming to yall, THE EXPERTS

 

[Pyrexcup]

This is like reading a foreign language lol



Nope. I've had my blog and domain name parked on Squarespace the past few years I so I'll run it from there. I guess I should look into what I can install on there



I don't know anything fam. That's why I'm coming to yall, THE EXPERTS

you could probably get what you want using wordpress to be honest

 

[Pete Wrigley]

There are so many options here but if you are looking to do this yourself, look into DataTables.

DataTables is a dynamic table UI that allows you to perform the features you're looking for. You can also pull the data from a database but of course you'll need some server-side scripts/programming to piece it together.

Not sure if it's a downside for you but DataTables is based on jQuery and if that does matter, there are alternatives out there but I haven't used them.

 

[Jekyll]

This is like reading a foreign language lol



Nope. I've had my blog and domain name parked on Squarespace the past few years I so I'll run it from there. I guess I should look into what I can install on there



I don't know anything fam. That's why I'm coming to yall, THE EXPERTS

Yeah I don’t know breh you probably want to hire someone. I’m sure you could find some intern online who needs project experience. Maybe expand the scope a little bit beyond just loading a single excel document.

 

[Macallik86]

One potential option is,instead of reinventing the wheel, you can do most of that in Google Sheets and then embed the spreadsheet IIRC. You could also reformat the spreadsheet to be complimentary to your website's CSS:

• Type to search (ex. if I type Motife43, I want all the rows with data pertaining to Motife to populate)
  • Spoiler
• view 75-100 results (rows) at a time on one page
• Sort by clicking a column header
  • Spoiler
• Have the capability to hover over a name with an asterisk and read a note (i.e. Motife43* - the asterisk reflects shelved album)
  • Spoiler
• Predictive search text (typing Mot should populate Motife43 as an option and filter/display as you type)
  • Spoiler

...

 

[Motife43]

One potential option is,instead of reinventing the wheel, you can do most of that in Google Sheets and then embed the spreadsheet IIRC. You could also reformat the spreadsheet to be complimentary to your website's CSS:

Wow. I knew Excel and Sheets had some great functionality when wielded properly but I didn't know it might be a solution for me

Thanks!

Repped everyone btw, appreciate the suggestions and advice