SQL is a language, not a database. And different SQL databases have different engines, one of those engines may suit your needs. In saying that though, I think there are better solutions than MySQL or MSSQL, but I believe they are both capable when setup correctly. I have little experience with different databases, but I have found elasticsearch with kibana great for time series and aggregation with a UI for graphing. https://www.elastic.co/kibana/ I had IOT devices that just throw a whole manner of different structured objects at it, and so long it had a time and index naming, it just worked.
Ovo je Kibana povezana na lokalni ElasticSearch klaster u kojeg sam indeksirao sve hreddit komentare. Inace sam trebao naucit ES za posao i trebala mi je hrpa nekakvih podataka, pa sam iskoristio to.
A timeseries visual, either in Lens or TSVB, would be my recommendation. Lens[1] has become really good at pivoting around different chart types which makes it ideal for quickly trying different viz styles (e.g., bar charts, line charts, etc). The goal is, as you noted, a viz element that would capture the story of what the story you're trying to tell in "how long/often a user is locking/unlocking their workstation".
Assuming you have Windows Event Logs in an index, you can put them in a time series visual, then filter by those event IDs, and/or by a user ID. You could try a 'terms' aggregation (aka 'group by') on the user IDs to group your users in the chart.
Does this help? I can give you more detailed pointers on using Lens if we're on the right path.
~~This is pretty cool. Sorry if this is a stupid question (or if I've missed something); One thing comes to mind is this almost looks like something Kibana does already. How would this function differently?~~
EDIT: sorry i definitely missed the point. So this is like Kibana but powered by Django and in real time. Actually thats really cool!
There is no console for Elasticsearch.
You may be thinking of Kibana, but that is a separate part of the Elastic Stack: https://www.elastic.co/kibana
Port 9200 for Elasticsearch is where you send formatted queries, or write requests.
Use an AWS IoT rule to route the incoming json to Elasticsearch (either the AWS managed version, which I'd probably recommend if you don't have ELK experience or self-managed EC2 machines). Visualize this data using Kibana.
> However, I have minimal experience using other programming languages so am wondering whether I should begin practicing with others to boost my chances of finding work?
Depends. If 90% of the entry-level job openings in your targeted area require C# knowledge, and you know nothing about it, yeah you might wanna learn C#. If 90% require Java, you're probably fine.
Look at what the job descriptions for your area are looking for, and learn those things well enough to answer some basic questions and confidently list them on your resume.
Conduct market analysis; I like using the Indeed API and word clouds powered by Elastic/Kibana.
> experience from before uni in the IT field ... Will this experience be useful in selling myself for software Dev roles?
You uhh ... should list any relevant work experience on your resume, yeah :) What's the alternative?