I really like that you showed the final result first, instead of starting from scratch directly. It gives an insight of what to expect from the tutorial. Excellent!
The relational ability of a database is a huge benefit over a spreadsheet. However, in my experience, the perhaps most important factor is data integrity - you can enter anything into a spreadsheet cell (for example all sorts of wrongly-formatted dates) but a database won't let you do this.
I’m a database enthusiast, I find so many uses for them in my business. I didn’t realise that Libre office had this powerful a relational database so will look at it, there are so many options in the design and setup that I didn’t know existed. This is so powerful, and for free. Thanks Chris.
I find LibreOffice Base to be amazingly complete and powerful (many other DBs which don't cost hundreds or thousands of US $) will do 1 or 2 things well, while LibreOffice Base does everything well. Sadly, watching the release notes of LibreOffice for the past 8 years or so it is clear that Base gets no developer love. Its features seem stuck, along with the rather ancient database engine which it uses, and at one time my already fully built and working DB began to crash LibreOffice consistently and it didn't improve over multiple releases, so I moved on to learning to build my own database using Python and SQLite.
It’s a thing, Chris, you always save me. You see, here in Argentina we are not going through a good economical time. And I upgraded my 12 years old computer following your videos to the letter. It works wondefully now - and I became a fan of Linux Mint. And now that I’m just starting with data bases, there came your video! I cannot begin to tell you how thankfull and how much I enjoy your channel. I’m of the ones who never write, but this time I just had to do it. Greetings!!
Yeah, I retired, and finally got fed up with MS and the performance of Win 10 on my machine(s). Kicked it and put Linux Mint on 5 machines dating back as far as 10 years probably. Love it, much peppier and stable. I was already a long time OO and then LO user, and found equivalents for everything else too.
@@almatematica7554 Yeah. It does. In my case as an IT pro for a large company, it was my gravy to know it well. But I retired, and that led eventually (when I found time....) to kick it out. I really do not missed Windows, and it feels sort of odd and antique to use it on rare occasion.
@@jackwarner4625 I saw Ferren OS on Distrowatch. Did not try it yet. For now, I am focused mainly on getting things done and not too much experimentation. That will come as I finish up some projects.
A long time ago I worked in an office obsessed with very complex and regularly broken spreadsheets. I suggested using the database instead but they gave me a blank look when I suggested they migrate it all to a database. They said no one would understand it, and the dumb ‘we don’t work like that’! I didn’t stay there for long, it just broke my heart after enduring watching them for hours trying to constantly fix broken field relationships in their excessively complex, critical spreadsheets. Loved this video ❤️.
That reminds me of when I worked for the IT contractor EDS, or it might have been Cap Gemini many years ago (as an admin, not tech person), and I heard one lady, the Excel and Access specialist, tell a colleague there was no way to get info in an Excel sheet into an Access Database. I could not help but say, "I have only basic Excel and Access skills, but I can do that in less than five minutes", to nods from others in the office. I don't remember those times with any real fondness, but your story amused me and brought that memory to mind.
Amazing. 35 years ago I started database design and programming using character based RDMS (this after an aircraft maintenance stint in the RAF, then emigrating to Canada to programming aircraft simulators). Retired now to tinkering with my SBCs and all things LINUX. Now, after pondering it for a while, I can renew my interest and create databases again. Wow, something else to keep me busy. Keep up the good work Chris.
I'm new to databases. This is one of the best database tutorials I've discovered. You have opened the door for me and the new possibilities are overwhelming. Practice, practice. Thank you.
Thanks for this. Practice is indeed the key. I wish you luck with LibreOffice Base -- there is a lot it can be used for if you are willing to learn, and it sounds like you are! :)
I know NOTHING, like that, in all caps about databases (well, at least I didn't before this video), but nonetheless I see what you did there. Like "I know I've seen that name somewhere before".
I can't believe database were that easy (I said that because I studied that in university and I just got super confused in the process). Your explanation was spot on and I understand everything here... Looking forward to what's next :DD
University also ruined it for me, that was 20 years ago. I’m a computer science teacher at a secondary school and - long story short - I had to learn it to be able to teach it. I had to refer to school books that were 20 years old and lots of UA-cam videos to try to make sense of databases. I feel a lot more confident with relational databases now and this video hits a good learning spot. I wanted to experience LibreOffice and this video does it for me. Love databases now, it filled that gap of computing science knowledge I never knew I never had.
very good intro. one can do every step on one's own computer while watching the video. minor comment to the first example: supplier names are best identified with an id as well, as strings are more error-prone, and names can change.
Thanks for this, and you are correct. But I did give the suppliers an ID in the example table. However, I also wanted to keep things as simple as possible in that first example. So I opted to show "Supplier" rather than "Supplier ID" in the first table to make the example as clear as possible. I could have spent a good 10 minutes talking about IDs and keys, but this was already a long video.
Another Sunday! With it, a very practical and useful explanation of databases. I couldn't imagine a better or more effective way to explain such an extremely complicated subject while touching on so many aspects. Designing, building, populating, querying, reporting, UI... And more all in one. Great video!
Thanks, Chris. This is a very good introduction to Base. I've played with it in the past to inventory trading cards. Turns out I was doing a lot of it right but this video takes it a step further for me. This video is better than any tutorial I've come across on UA-cam. Regards.
A far cry from the 8-bit databases of my youth..... where, often written in BASIC and machine code,, you had about 5 fields.....no more 🙂 Thanks for this Chris, I never went beyond Presenter, Word Processor and Draw in LibreOffice, so I have no excuses anymore. Until next time, take care!
Great video. I was a power user back in the dBase DOS days, then was out of the field for 20 years. When I next needed a database manager, Access stymied me. Every tutorial began with the equivalent of "When you hear the cat's bell, run." Like most I limped along using a spreadsheet for things like mail merge. Now I can resume using a proper database manager.
This was an excellent crash course in database design and rapid application development. I've tried Base a million times but it never took. For me, the learning curve was too much and I already know how to do it in Access (or sever grade databases, Oracle, MariaDB and SQl server). I kind of feel that way about all Open Office and LibreOffice products. Unfortunately Microsoft indoctrinated me at an early age. I will overcome the spell of Microsoft soon enough and I will do it with your excellent tutorials. Thank you!!!!
At the beginning of the next year I will visit my relatives, some of them young with a lot of curiosity, immersed in our work areas we make the mistake of assuming that everyone knows everything, instead of boring them with my words, I can now show this video to those minds of all ages interested in knowing a little about how the world around them works.
As a visual learner, this was a wonderful video. Making everything and going through step by step. I'm going to need to re-watch it a few times to fully understand, but it's really helpful and well explained. Thanks for sharing this.
Thank you for this enlightening presentation. I worked for a while as a database admin long before LibreOffice or OpenOffice. I was vaguely aware that LO had a database but never looked at it seriously. Well, never actually looked at it at all. I'm very impressed with how simple, yet complete it is.
I just started the video, but I can’t tell you how excited I am that you made this! I’ve been wanting to learn about databases and you are the perfect person to learn the basics from!
It's interesting that I've worked with a few organizations that use spreadsheets to keep rather complex records. Each time I see them doing that I think, "they should be using a database". Now I may be better able to convince them of that by showing them this video.
There was a rather embarrassing example of this misuse of spreadsheets on a nationwide basis back in 2020, when Public Health England was supposed to be keeping track of monthly COVID-19 case numbers. For about three months, they were underreporting numbers without realizing it, because they were trying to import too many rows into an Excel spreadsheet, and it was quietly dropping the excess. There is a whole website dedicated to collecting instances of these sorts of Excel bugs, they are that numerous. And ongoing.
You have condensed into 30 minutes what it took my graduate level DB concepts professor 6 weeks to cover 🤔 Throw in a discussion on "normalization" and I could have tested out 😃
Don't omit relational integrity, NULL, transactions and touch on "stored procedures". There are also unwritten rules such as *never* making the keys user-visible let alone editable.
Thank you, Chris, for another excellent video. I started my career as a relational database developer long before Windows existed. I wish you had been teaching back then, but of course you were also a kid…lol. At least your viewers today can learn a lot from you about a topic that’s still relevant today as it was decades ago. I hope you continue this series and introduce no-sql databases, and compare, contrast, and show when, how, and why both are used today in cloud computing. Thanks again for yet another excellent video!
I work with databases at the job and the video was remedial, but very useful for those times when I need to explain(ing computers) to other professionals.
To anyone who wants to get started with relational databases, I always recommend SQL Server (the Developer Edition is free to use for testing). It's got some great graphic tools, not just for development, but also for administration (backup, restore...) Once you understand the main principles, then you can switch to other databases (postgres, MariaDB, etc.) which have other great qualities, but whose tools are not always as easy to use as SQL Server Management Studio (there is often a lot of scripting involved...)
Those of us who have abandoned M$ and are dedicated Linux users would rather not use SQL Server. I still don't think M$ is really as dedicated to FOSS as they say they are. Jut my opinion.
@@jimlynch9390 I suggest PostgreSQL, because it comes with pgadmin which is quite good from what I have heard. I personally never needed more than sqlite. :)
I am as new to this as someone can be. Are you recommending a piece of software to use INSTEAD of the LibreOffice software shown in the video? Or is that software you would use in addition to this?
@@jimlynch9390 I agree. If you want to really learn databases, starting from postgresql isn't a bad move. That's coming from someone who's used most databases on the market in a professional capacity.
@@MrThedennisblack LibreOffice can attach to a few different SQL servers, but also has its own built in SQL system. You can learn the majority of database principles using just LibreOffice if you want. It will let you create SQL queries like you'd use with a server, but still has the GUI to help out.
Your video is absolutely comprehensive and straightforward. Please have a series of this topic as you sound an expert in databases. You did it right! I've studied relational database before but haven't have the chance to use it. But for me, you really showed it SUPER EASY (because we have now MS Access, Libre Base, etc...) Before we use dBaseIII+ and FoxPro, and it's hard to do it at that time as we need to open, index, select, etc... the databases first to do a query and do the applicable results that we need, and we need to write a program for it. Thanks and please make a series for this topic.
If this is going to be a new series of tutorials of Libre Office Base that are up to date then this will be a dream come true for me. I have had an enormous amount of trouble finding help online with learning to use this
Thank you for the tutorial. I've been avoiding the task of building a database and reports for a few things that I need for year-end in our home business. Up to now I've been using LibreOffice's Calc as a crutch, making summary spreadsheets of weekly spreadsheets ... almost all of which, I think I can convert eventually into a set of database tables, forms for weekly input, and a bunch of reports for what we want to see after. Again, thank you for the tutorial showing how versatile Base is.
SQLite is also useful for ad-hoc data-collation uses. Example: I got a list of a few thousand records to process for a client (in an Excel spreadsheet, of course). I use LibreOffice Calc to convert it to CSV format, then a custom Python script to import that to an SQLite database, with NULLs in the processed-status fields. Now I can run the actual processor on the SQLite file, filling in the statuses as it processes the records. I can stop this process at any time (it is quite time-consuming) and when I resume it, it simply skips the already-processed records and continues with the unprocessed ones. When all the records are done, I use a third script to export the data to CSV, which I can send back to the client.
Thank you for showing us the wonders that we can accomplish using free & powerful software. I am retired and was trying to learn SQL for kicks. I spent half a day to create a table and get some entries in. Libre Base has the best of both worlds. The graphical interface, your great tutorial in simple terms and the mighty software behind helps us to understand the relationship between tables. Kudos for showing us how joining tables can be done in a jiffy. Thank you very much. You have helped me learn.
I've mostly worked with Oracle in my professional life but recently I needed a database for a home project so I downloaded and installed SQLite 3. I was very impressed at the functionality, the SQL is quite rich, supports analytical functions and it runs well on a Raspberry pi.
As a career database administrator (DBA) there are lots of areas I could nit pick, but... Your video didn't say databases for experts🙂. So for the audience it was aimed at, I say excellent work! I did even learn something new. I didn't know Libre Office had a database application in it. Looks pretty full featured and intuitive as well.
Brilliant video in explaining so much in so little time. I've used LO Base a few times but picked up a lot from this video. The 2 things I missed after ditching MS Widows and moving to Linux, were MS Access and VB 6.0. Gambas solved the VB issue and for the most part LO Base solved the MS Access issue with one major exception. All I need from LO Base is the ability to have 2 laptops, access a LO Base file on my NAS or a Raspberry Pi. Using virtually every combination of CHOWN and setting permissions to 777 etc, I can not get either Linux Mint laptop to write to a LO Base [or SQLite for that matter] on my NAS [RPi with OpenMediaVault] or a standalone RPi with a Thumbdrive. I can never get permissions for a write even though I can copy/paste/delete the entire file into either device. Maybe one of your subscribers has been there and done that.
how are you sharing the file, samba? libreoffice is a bit funny about network shares, iirc it will copy the file to temp to work with it, not directly touch it. i dont know if NFS solves this. i use a command to mount my samba as cifs. doesnt always work at startup for some reason, but its one click away to mount in dolphin and it helps a bit with weird apps that cant decide how to do network files.
Very good overview. I used MS Access to developed Desktop databases to help my office works. To me MS Access is an excellent desktop database to develop professional looking database applications. When I moved to Linux, there was no database similar to Access. Glad to see that LibreOffice Base has updated to some what like MS Access.
Chris, I really liked this week's topic. I used to work as an Inventory Controller of a £6.6M warehouse and so generating reports from data interrogation was an often-daily occurrence. Thanks for all your hard work, Be happy and well. Brian
Nowadays, whenever we want something we look for an application to do it for us, while in most cases we can create what we need ourselves using already installed software and enjoy the learning/achievement process. Software is made for one purpose or another and once we know what that is we'll appreciate it. Very nice intro to DB indeed, it covers the DB design cycle from planning to reporting. Thanks Chris and have a nice Day/Evening.
The word “relation”comes from Edgar Frank Codd's theorem that bases on relational calculus. In his relational model, the term “relation” corresponds to what was called “table” in the above video.
I knew how to work with sql databases. But just editing existing ones (even their front ends). Never thought that creating one was so easy and straightforward. Don't get me wrong, I still think that implement them on a website is another whole world. But for local use, this tutorial is a game changer for me. I don't have much use for databases right now, but now I know how to use them. Before I didn't even bother to learn the basics.
I have seen less insight given within a textbook than has been given here. My first excursion into relational DBs was with dBase and then FoxPro (before microsoft got their hands on it). I understood that an efficient dB was a full dB and I saw a dBase of information in another department, written by a Pro-Programmer using a Spreadsheet 90% of which had data fields empty. It half filled a 20MB (yes megabytes this was in the 80s/90s) PS2-30 computer. Programmer was really proud of his monstrosity. I think dBase had limited relationship capabity (one link I think) but FoxPro (both DOS) was wonderful and queries were a breeze. I don't have a need for a Relational Database now but I am glad I watched this.
Thanks for clarifying this. At the time I tried _Base,_ the documentation wasn't very good, and I hadn't used any other real databases. Now I look forward to your next 4.3 billion SoC reviews! 😁👍
Greetings!! A nearly entire database course in under 30 minutes. Very well done sir! Your longest video ever and one of the best. Now I should create a duplicate of this for my SBC collection. I do have ONE criticism at 3:51 there is an existing database file called Sausages. Made me hungry but you didn't show us that database. :) Stay well my friend!!
I have never 'got' databases (not least because all the examples/tutorials I've watched read deal with usecases that seem entirely different from my own) but your approach has really opened my eyes. Thanks so much!!! I'm off to explore your spreadsheet ones now. I can't believe I've missed them previously.
Very cool video that shows how to perform the most common operations in creating a database using LibreOffice Base. As a longtime Microsoft Access user, I find that both programs are largely similar and quite capable of delivering sophisticated end user applications. Thanks for providing this concise yet thorough tutorial on creating and using databases with LibreOffice!
Thanks for creating this introduction to LIbreoffice Base. It's kind of overwhelming to get started with Base but your video really helps with showing the basics for getting started.
This is a great addition to your repertoire of presentations. I am sure it will attract more viewers in the long term if you make a regular addition. It gets my vote, great stuff!
Thanks for this. I decided to make this video as my series of spreadsheet tutorials from six years ago continues to get good traffic. So my hope is certainly that is video will have a stable view stream. :)
Databases are *great* if you have a collection of something. I used to use Excel to keep track of a couple of collections of mine, and it worked fine, but I decided to see if I could make it easier on the eyes so I started playing around with Access. I think it's easier to enter and retrieve this type of information in a database and you can make it look like however you want. I love Excel, but databases are better for keeping track of collections of stuff IMO. Another great video Chris. Thanks!
Thankyou for another video explaining data bases. It is amazing what can be done if given time. Not that long ago software like this would have cost an arm and a leg and only companies would have access to them.
So true. It is amazing the software power now available to almost anybody. The free LibreOffice Base could run on a Raspberry Pi, let alone any modern PC.
As usual, a concise but very clear explaination. Your presentation style, including your sense of humor and mannerisms, reminds me of one of my high school science teachers, who was my alll-time favorite.
Thank you for the nice explanation on how to setup LibreOffice database. Setup a few MS Office Access databases but never used LibreOffice Base, and steps look to be the same. Just one of those guys that do everything in Excel, Calc now. Never really see the need for Access or Base unless you need to do reports or setup data entry for others.
I have a lot of experience with MS Access, but have moved to daily driving Linux for over a year, so let go of MS Office. I never realised how similar Base was to Access's flow. This is yet another notch in the belt for me never have to go back to the Microsoft ecosystem, but still being able to build cross platform applications. It doesn't really have an equivalent to VBA but still small database applications can easily be built agnostic to the OS of the PC. Thanks for a great video.
Hi! Ludite here. I've been using Memento Database for years now. I use it mainly for storage of records for my business, but ultimately, at the end of each job, I need to generate reports which has been painfully tedious for me. And the forum is hit or miss: they clearly hate ludites. This video was helpful to me and I would very much appreciate more database content.
Thank you for making this video. When I did my GCSEs 20+ years ago I used Microsoft Office and the database work is the part that I have the poorest recollection - probably because of the amount of preparatory work involved in databases vs the ready-to-work aspect of wordprocessor and spreadsheet software. As far as I now remember, there is quite a lot of overlap between this workflow and that on Office '97.
Really good presentation. The wall I hit when studying sql databases was joins... It takes memorization to know which join command(s) to use properly in a query. But with applications like MS Access, or Libre Base you don't have to know those commands, just the logic of the data connections. Thanks for another great video.
Aloha, Chris. This was fantastic. It had never occurred to me to use a database in my work, but after watching your presentation I can say I will be changing that. I appreciate, yet again, the time and effort you put into these weekly videos. Mahalo.
An excellent introductory video for those of us who have never used database programs before. Thank you for the overview and presenting so much information in a friendly and comprehensive way. Be safe.
well done EC, I learned more in your 30 minute vid, than in a bachelors level DB distance learning college course from 15 years ago..thanks for sharing the knowledge!
May be useful in the future - I haven't felt the need for a database yet. If and when I do, I'll probably have to watch this several times as I did not find it either simple or straightforward! 😆
WOW! My head is spinning. LOTS packed into half an hour. All good and very interesting. Now I need to make a list of time points in the vid so that I can refer to each concept to allow me to move forward with the learning process. Maybe I should create a database about each little segment of the vid - LOL.
Thanks for this. The video has labelled chapters if you hover over the progress bar at the bottom. Or you can see the chapters and timestamps listed at the end of the video description.
If you're actually curious, the list box bound column is defaulted to 1 because it assumes you don't want to bind to the first column, usually the ID column, which is usually just an uninformative autonumber value in most tables. Picking from a list of IDs isn't helpful compared to picking from a more informative column, like name or model or something.
It is common in UI selections to show a list of descriptive values to the user, but to store unique IDs for each option in the backend, and use those to represent the actual selection that was made.
Thanks💝 for this tutorial. I'm tired of searching for this database tutorial using libreoffice base which may be easy to start to learn instead of Querying database tutorial. And your explanation starting with the applications of learning databases is awesome🤩 idea which stimulates the user to learn this lesson. I request you to do more videos regarding this.
I don't usually post on computer related sites, but I actually have many years working in information technology and services, even going back to the days of 16bit windows, close to inception of the first Linux distro's as well hardware as old as 8088 and 8080 XT PCs and micro computers. The content that you Sir, have on every video that I have ever viewed on your channel has ALWAYS been top professional produced content towards Linux, applications and affordable computing options. The UA-cam community as a whole is really lucky to have you. I like to wish you and yours all the best this holiday season and a great new year! - MrTom
You can do as many as you like of this kind of video! I love it, love the instructions, love the use of LibreOffice. And I would very happily watch more detailed videos and use of LibreOffice Base/Calc etc
I forgot to say that I did a 3-part series on spreadsheets (using OpenOffice, so works in LibreOffice) a few years back: Starts here: ua-cam.com/video/7Q2C9MB-YH4/v-deo.html then ua-cam.com/video/Pm_raXxS8u8/v-deo.html then ua-cam.com/video/iFz82q4vHnk/v-deo.html
Thanks Chris. I have wanted to create a database of all my physical music for a long time. The goal is to find a track easily if I get a request from a listener on my radio show. I think I will give it a go now. There will be a lot of typing involved so it's going to be a winter project.
If the physical music includes CD, then you can save some typing by referencing CDDB, an open database of CD information based on the CD ID. I don't know how it works but backing up my media using "ripper" programs has them pick up the right information automatically. Mostly. Other times you edit the details. An alternative is to scan the EAN/GTIN barcode and pull the information off the WWW.
This will come in handy while cleaning my parent's garage :) You always explain things in a humanly understandable way. Thank you for the awesome introduction, Mr. Barnatt!
I really like that you showed the final result first, instead of starting from scratch directly. It gives an insight of what to expect from the tutorial. Excellent!
I decided that, given the setup required to create the tables and forms, that I needed to signpost where we were heading! :)
@@ExplainingComputers That was a very wise decision, indeed! 😀
Agreed...its good to see the mountain that we were about to climb before hand.
I love that method, I want to see what we are doing.
I agree, it's a sort of reverse-engineering, you can see the cogs going round, what they do and in relation to everything else.
Tremendous. Most people don't know why they need a database, until they do👍🏻
Most people think I can do that in excel/a spreadsheet.
Wrong but they do.
And many don’t know something else to Excel exi😂
Excel can do it but a database program still has advantages. Like, for example, not being Excel! 😆
um
The relational ability of a database is a huge benefit over a spreadsheet. However, in my experience, the perhaps most important factor is data integrity - you can enter anything into a spreadsheet cell (for example all sorts of wrongly-formatted dates) but a database won't let you do this.
I’m a database enthusiast, I find so many uses for them in my business. I didn’t realise that Libre office had this powerful a relational database so will look at it, there are so many options in the design and setup that I didn’t know existed. This is so powerful, and for free. Thanks Chris.
It seems to be a solid clone of MS Access.... Which has had pretty good power and options for nearly 25 years.
LibreOffice Base is just a front end to various DBMSes. There is even one for SQLite somewhere. All of them are more powerful than Microsoft Access.
I find LibreOffice Base to be amazingly complete and powerful (many other DBs which don't cost hundreds or thousands of US $) will do 1 or 2 things well, while LibreOffice Base does everything well.
Sadly, watching the release notes of LibreOffice for the past 8 years or so it is clear that Base gets no developer love. Its features seem stuck, along with the rather ancient database engine which it uses, and at one time my already fully built and working DB began to crash LibreOffice consistently and it didn't improve over multiple releases, so I moved on to learning to build my own database using Python and SQLite.
It’s a thing, Chris, you always save me. You see, here in Argentina we are not going through a good economical time. And I upgraded my 12 years old computer following your videos to the letter. It works wondefully now - and I became a fan of Linux Mint. And now that I’m just starting with data bases, there came your video!
I cannot begin to tell you how thankfull and how much I enjoy your channel. I’m of the ones who never write, but this time I just had to do it. Greetings!!
Thanks for your kind feedback, most appreciated. :)
Yeah, I retired, and finally got fed up with MS and the performance of Win 10 on my machine(s).
Kicked it and put Linux Mint on 5 machines dating back as far as 10 years probably.
Love it, much peppier and stable. I was already a long time OO and then LO user, and found equivalents for everything else too.
@@ContantContact It leaves you thinking 'what have I been doing all this time with windows...?'
@@almatematica7554
Yeah. It does.
In my case as an IT pro for a large company, it was my gravy to know it well.
But I retired, and that led eventually (when I found time....) to kick it out. I really do not missed Windows, and it feels sort of odd and antique to use it on rare occasion.
@@jackwarner4625
I saw Ferren OS on Distrowatch. Did not try it yet. For now, I am focused mainly on getting things done and not too much experimentation. That will come as I finish up some projects.
A long time ago I worked in an office obsessed with very complex and regularly broken spreadsheets. I suggested using the database instead but they gave me a blank look when I suggested they migrate it all to a database. They said no one would understand it, and the dumb ‘we don’t work like that’! I didn’t stay there for long, it just broke my heart after enduring watching them for hours trying to constantly fix broken field relationships in their excessively complex, critical spreadsheets. Loved this video ❤️.
That reminds me of when I worked for the IT contractor EDS, or it might have been Cap Gemini many years ago (as an admin, not tech person), and I heard one lady, the Excel and Access specialist, tell a colleague there was no way to get info in an Excel sheet into an Access Database. I could not help but say, "I have only basic Excel and Access skills, but I can do that in less than five minutes", to nods from others in the office. I don't remember those times with any real fondness, but your story amused me and brought that memory to mind.
You should've made a demo instead of trying to explain
Amazing. 35 years ago I started database design and programming using character based RDMS (this after an aircraft maintenance stint in the RAF, then emigrating to Canada to programming aircraft simulators). Retired now to tinkering with my SBCs and all things LINUX. Now, after pondering it for a while, I can renew my interest and create databases again. Wow, something else to keep me busy. Keep up the good work Chris.
I'm new to databases. This is one of the best database tutorials I've discovered. You have opened the door for me and the new possibilities are overwhelming. Practice, practice. Thank you.
Thanks for this. Practice is indeed the key. I wish you luck with LibreOffice Base -- there is a lot it can be used for if you are willing to learn, and it sounds like you are! :)
Such a simple, yet powerful, database seems like quite a Paradox. Borland would be proud.
I know NOTHING, like that, in all caps about databases (well, at least I didn't before this video), but nonetheless I see what you did there. Like "I know I've seen that name somewhere before".
I can't believe database were that easy (I said that because I studied that in university and I just got super confused in the process).
Your explanation was spot on and I understand everything here...
Looking forward to what's next :DD
Thanks for this. :)
University also ruined it for me, that was 20 years ago. I’m a computer science teacher at a secondary school and - long story short - I had to learn it to be able to teach it. I had to refer to school books that were 20 years old and lots of UA-cam videos to try to make sense of databases. I feel a lot more confident with relational databases now and this video hits a good learning spot. I wanted to experience LibreOffice and this video does it for me. Love databases now, it filled that gap of computing science knowledge I never knew I never had.
very good intro. one can do every step on one's own computer while watching the video.
minor comment to the first example: supplier names are best identified with an id as well, as strings are more error-prone, and names can change.
Thanks for this, and you are correct. But I did give the suppliers an ID in the example table. However, I also wanted to keep things as simple as possible in that first example. So I opted to show "Supplier" rather than "Supplier ID" in the first table to make the example as clear as possible. I could have spent a good 10 minutes talking about IDs and keys, but this was already a long video.
yes, perfectly understandable decision in this context.
Another Sunday!
With it, a very practical and useful explanation of databases. I couldn't imagine a better or more effective way to explain such an extremely complicated subject while touching on so many aspects.
Designing, building, populating, querying, reporting, UI... And more all in one. Great video!
Thanks. :)
Thanks, Chris. This is a very good introduction to Base. I've played with it in the past to inventory trading cards. Turns out I was doing a lot of it right but this video takes it a step further for me. This video is better than any tutorial I've come across on UA-cam. Regards.
A far cry from the 8-bit databases of my youth..... where, often written in BASIC and machine code,, you had about 5 fields.....no more 🙂
Thanks for this Chris, I never went beyond Presenter, Word Processor and Draw in LibreOffice, so I have no excuses anymore.
Until next time, take care!
Great video. I was a power user back in the dBase DOS days, then was out of the field for 20 years. When I next needed a database manager, Access stymied me. Every tutorial began with the equivalent of "When you hear the cat's bell, run." Like most I limped along using a spreadsheet for things like mail merge. Now I can resume using a proper database manager.
Sometimes, the data layout or size isn't suitable for a spreadsheet nor a document. Your tutorial is amazing to start with.
Great video. I have never seen why people use spreadsheets as databases when actual databases are so easy to use and do the job so much better.
This was an excellent crash course in database design and rapid application development. I've tried Base a million times but it never took. For me, the learning curve was too much and I already know how to do it in Access (or sever grade databases, Oracle, MariaDB and SQl server). I kind of feel that way about all Open Office and LibreOffice products. Unfortunately Microsoft indoctrinated me at an early age. I will overcome the spell of Microsoft soon enough and I will do it with your excellent tutorials. Thank you!!!!
At the beginning of the next year I will visit my relatives, some of them young with a lot of curiosity, immersed in our work areas we make the mistake of assuming that everyone knows everything, instead of boring them with my words, I can now show this video to those minds of all ages interested in knowing a little about how the world around them works.
As a visual learner, this was a wonderful video. Making everything and going through step by step. I'm going to need to re-watch it a few times to fully understand, but it's really helpful and well explained. Thanks for sharing this.
Thank you for this enlightening presentation. I worked for a while as a database admin long before LibreOffice or OpenOffice. I was vaguely aware that LO had a database but never looked at it seriously. Well, never actually looked at it at all. I'm very impressed with how simple, yet complete it is.
I just started the video, but I can’t tell you how excited I am that you made this! I’ve been wanting to learn about databases and you are the perfect person to learn the basics from!
It's interesting that I've worked with a few organizations that use spreadsheets to keep rather complex records. Each time I see them doing that I think, "they should be using a database". Now I may be better able to convince them of that by showing them this video.
There was a rather embarrassing example of this misuse of spreadsheets on a nationwide basis back in 2020, when Public Health England was supposed to be keeping track of monthly COVID-19 case numbers. For about three months, they were underreporting numbers without realizing it, because they were trying to import too many rows into an Excel spreadsheet, and it was quietly dropping the excess.
There is a whole website dedicated to collecting instances of these sorts of Excel bugs, they are that numerous. And ongoing.
You have condensed into 30 minutes what it took my graduate level DB concepts professor 6 weeks to cover 🤔 Throw in a discussion on "normalization" and I could have tested out 😃
Don't omit relational integrity, NULL, transactions and touch on "stored procedures".
There are also unwritten rules such as *never* making the keys user-visible let alone editable.
I didn't even know that you can setup a database through LibreOffice with rich GUI, smashed the like button right after the intro!
Thank you, Chris, for another excellent video. I started my career as a relational database developer long before Windows existed. I wish you had been teaching back then, but of course you were also a kid…lol. At least your viewers today can learn a lot from you about a topic that’s still relevant today as it was decades ago. I hope you continue this series and introduce no-sql databases, and compare, contrast, and show when, how, and why both are used today in cloud computing. Thanks again for yet another excellent video!
Way more depth in relational databases to touch Such as indexes
I work with databases at the job and the video was remedial, but very useful for those times when I need to explain(ing computers) to other professionals.
All the key points covered nicely. Well done. Retired database and application developer at Intel.
Very good, takes me back 25 years, setting up relational databases to optimise the performance of surface mount placement machines...
To anyone who wants to get started with relational databases, I always recommend SQL Server (the Developer Edition is free to use for testing).
It's got some great graphic tools, not just for development, but also for administration (backup, restore...)
Once you understand the main principles, then you can switch to other databases (postgres, MariaDB, etc.) which have other great qualities, but whose tools are not always as easy to use as SQL Server Management Studio (there is often a lot of scripting involved...)
Those of us who have abandoned M$ and are dedicated Linux users would rather not use SQL Server. I still don't think M$ is really as dedicated to FOSS as they say they are. Jut my opinion.
@@jimlynch9390 I suggest PostgreSQL, because it comes with pgadmin which is quite good from what I have heard.
I personally never needed more than sqlite. :)
I am as new to this as someone can be. Are you recommending a piece of software to use INSTEAD of the LibreOffice software shown in the video? Or is that software you would use in addition to this?
@@jimlynch9390 I agree. If you want to really learn databases, starting from postgresql isn't a bad move. That's coming from someone who's used most databases on the market in a professional capacity.
@@MrThedennisblack
LibreOffice can attach to a few different SQL servers, but also has its own built in SQL system. You can learn the majority of database principles using just LibreOffice if you want. It will let you create SQL queries like you'd use with a server, but still has the GUI to help out.
Hi Chris - this is where your channel excels. (!). A useful set of introductions to things I will probably want to do one day. Thumbs up.
Thanks. :)
Your video is absolutely comprehensive and straightforward. Please have a series of this topic as you sound an expert in databases. You did it right! I've studied relational database before but haven't have the chance to use it. But for me, you really showed it SUPER EASY (because we have now MS Access, Libre Base, etc...) Before we use dBaseIII+ and FoxPro, and it's hard to do it at that time as we need to open, index, select, etc... the databases first to do a query and do the applicable results that we need, and we need to write a program for it. Thanks and please make a series for this topic.
If this is going to be a new series of tutorials of Libre Office Base that are up to date then this will be a dream come true for me. I have had an enormous amount of trouble finding help online with learning to use this
Pretty cool from Chris to post this video, as Base is the only LibreOffice application I don't use.
Thank you for the tutorial. I've been avoiding the task of building a database and reports for a few things that I need for year-end in our home business.
Up to now I've been using LibreOffice's Calc as a crutch, making summary spreadsheets of weekly spreadsheets ... almost all of which, I think I can convert eventually into a set of database tables, forms for weekly input, and a bunch of reports for what we want to see after.
Again, thank you for the tutorial showing how versatile Base is.
Good luck with your future conversion to Base! :)
SQLite is also useful for ad-hoc data-collation uses.
Example: I got a list of a few thousand records to process for a client (in an Excel spreadsheet, of course). I use LibreOffice Calc to convert it to CSV format, then a custom Python script to import that to an SQLite database, with NULLs in the processed-status fields.
Now I can run the actual processor on the SQLite file, filling in the statuses as it processes the records. I can stop this process at any time (it is quite time-consuming) and when I resume it, it simply skips the already-processed records and continues with the unprocessed ones.
When all the records are done, I use a third script to export the data to CSV, which I can send back to the client.
DBA for 25 years. This reminds me of the old dBase IV days in college. So effective with so little work required to be productive. Fun video.
Thank you for showing us the wonders that we can accomplish using free & powerful software. I am retired and was trying to learn SQL for kicks. I spent half a day to create a table and get some entries in. Libre Base has the best of both worlds. The graphical interface, your great tutorial in simple terms and the mighty software behind helps us to understand the relationship between tables. Kudos for showing us how joining tables can be done in a jiffy. Thank you very much. You have helped me learn.
Thank you sir, in all the videos I had watched, only yours that made me understand the libreoffice base. May god bless you.
Oh please do more of these! I’ve been looking for something like this for years!
I've mostly worked with Oracle in my professional life but recently I needed a database for a home project so I downloaded and installed SQLite 3. I was very impressed at the functionality, the SQL is quite rich, supports analytical functions and it runs well on a Raspberry pi.
Amazing! Just how many times you read my mind on what I want to learn or enhance just what I need each week! Thank you!
Greetings Leslie. Look our for part of next week's video that may strike a (DOS) chord. :)
As a career database administrator (DBA) there are lots of areas I could nit pick, but...
Your video didn't say databases for experts🙂. So for the audience it was aimed at, I say excellent work! I did even learn something new. I didn't know Libre Office had a database application in it. Looks pretty full featured and intuitive as well.
Thanks Richard, on all counts here. :)
I was looking for an alternative to Access for the school I teach in too. Who else is better than you - no one! 😊
No exaggeration, this is probably the third or fourth time I was starting to explore a subject and up popped an EC video on the very topic!
I was not aware that LibreDase had so much functionality. I need to delve into this a little more. Thanks for quick tutorial it's most helpful.
Brilliant video in explaining so much in so little time. I've used LO Base a few times but picked up a lot from this video. The 2 things I missed after ditching MS Widows and moving to Linux, were MS Access and VB 6.0. Gambas solved the VB issue and for the most part LO Base solved the MS Access issue with one major exception.
All I need from LO Base is the ability to have 2 laptops, access a LO Base file on my NAS or a Raspberry Pi. Using virtually every combination of CHOWN and setting permissions to 777 etc, I can not get either Linux Mint laptop to write to a LO Base [or SQLite for that matter] on my NAS [RPi with OpenMediaVault] or a standalone RPi with a Thumbdrive. I can never get permissions for a write even though I can copy/paste/delete the entire file into either device. Maybe one of your subscribers has been there and done that.
how are you sharing the file, samba? libreoffice is a bit funny about network shares, iirc it will copy the file to temp to work with it, not directly touch it. i dont know if NFS solves this. i use a command to mount my samba as cifs. doesnt always work at startup for some reason, but its one click away to mount in dolphin and it helps a bit with weird apps that cant decide how to do network files.
Very good overview. I used MS Access to developed Desktop databases to help my office works. To me MS Access is an excellent desktop database to develop professional looking database applications. When I moved to Linux, there was no database similar to Access. Glad to see that LibreOffice Base has updated to some what like MS Access.
Chris, I really liked this week's topic. I used to work as an Inventory Controller of a £6.6M warehouse and so generating reports from data interrogation was an often-daily occurrence. Thanks for all your hard work, Be happy and well. Brian
Thanks Brian. :)
Nowadays, whenever we want something we look for an application to do it for us, while in most cases we can create what we need ourselves using already installed software and enjoy the learning/achievement process.
Software is made for one purpose or another and once we know what that is we'll appreciate it.
Very nice intro to DB indeed, it covers the DB design cycle from planning to reporting.
Thanks Chris and have a nice Day/Evening.
The word “relation”comes from Edgar Frank Codd's theorem that bases on relational calculus.
In his relational model, the term “relation” corresponds to what was called “table” in the above video.
I wasn't even aware that LibreOffice had a database component since it's not included with my default installation. Thanks for the demo.
I knew how to work with sql databases. But just editing existing ones (even their front ends).
Never thought that creating one was so easy and straightforward.
Don't get me wrong, I still think that implement them on a website is another whole world. But for local use, this tutorial is a game changer for me.
I don't have much use for databases right now, but now I know how to use them. Before I didn't even bother to learn the basics.
I have seen less insight given within a textbook than has been given here.
My first excursion into relational DBs was with dBase and then FoxPro (before microsoft got their hands on it). I understood that an efficient dB was a full dB and I saw a dBase of information in another department, written by a Pro-Programmer using a Spreadsheet 90% of which had data fields empty. It half filled a 20MB (yes megabytes this was in the 80s/90s) PS2-30 computer. Programmer was really proud of his monstrosity.
I think dBase had limited relationship capabity (one link I think) but FoxPro (both DOS) was wonderful and queries were a breeze.
I don't have a need for a Relational Database now but I am glad I watched this.
Very informative and well-done tutorial. Thanks Chris.
Thanks for clarifying this. At the time I tried _Base,_ the documentation wasn't very good, and I hadn't used any other real databases. Now I look forward to your next 4.3 billion SoC reviews! 😁👍
Very clearly presented. Thank you.
Greetings!! A nearly entire database course in under 30 minutes. Very well done sir! Your longest video ever and one of the best. Now I should create a duplicate of this for my SBC collection. I do have ONE criticism at 3:51 there is an existing database file called Sausages. Made me hungry but you didn't show us that database. :) Stay well my friend!!
I know. It was great, wasn't it?
This was EXACTLY what I needed. Just the right level of detail for my purposes. Thank you so much for creating this. It's a great piece of work!
Thanks for watching, and good luck with Base.
I too like fiddling with base and really enjoy this kind of content. Your unique style really makes exploring this application fun and come to life.
I have never 'got' databases (not least because all the examples/tutorials I've watched read deal with usecases that seem entirely different from my own) but your approach has really opened my eyes. Thanks so much!!! I'm off to explore your spreadsheet ones now. I can't believe I've missed them previously.
Very cool video that shows how to perform the most common operations in creating a database using LibreOffice Base. As a longtime Microsoft Access user, I find that both programs are largely similar and quite capable of delivering sophisticated end user applications. Thanks for providing this concise yet thorough tutorial on creating and using databases with LibreOffice!
Thanks for creating this introduction to LIbreoffice Base. It's kind of overwhelming to get started with Base but your video really helps with showing the basics for getting started.
Excellent! Concise with enough detail to show the how-to-do-it. I've learned something. Thank you.
This is a great addition to your repertoire of presentations. I am sure it will attract more viewers in the long term if you make a regular addition. It gets my vote, great stuff!
Thanks for this. I decided to make this video as my series of spreadsheet tutorials from six years ago continues to get good traffic. So my hope is certainly that is video will have a stable view stream. :)
Thank you for this; database stuff is one area where my IT expertise is lacking. Very much appreciated!
Databases are *great* if you have a collection of something. I used to use Excel to keep track of a couple of collections of mine, and it worked fine, but I decided to see if I could make it easier on the eyes so I started playing around with Access. I think it's easier to enter and retrieve this type of information in a database and you can make it look like however you want. I love Excel, but databases are better for keeping track of collections of stuff IMO. Another great video Chris. Thanks!
I could not agree more. There comes a point where the database beats the spreadsheet. :)
Thankyou for another video explaining data bases. It is amazing what can be done if given time. Not that long ago software like this would have cost an arm and a leg and only companies would have access to them.
So true. It is amazing the software power now available to almost anybody. The free LibreOffice Base could run on a Raspberry Pi, let alone any modern PC.
"Hopefully I provided a useful introduction". You did, thank you.
This is video has so much value! Easy to understand and covers all basic operations in 30 minutes. Amazing job.
Amazing explanation as always, thank you Chris!
As usual, a concise but very clear explaination. Your presentation style, including your sense of humor and mannerisms, reminds me of one of my high school science teachers, who was my alll-time favorite.
Thanks. :)
Thanks for taking time to prepare a tutorial on this important subject.
Thank you for the nice explanation on how to setup LibreOffice database. Setup a few MS Office Access databases but never used LibreOffice Base, and steps look to be the same. Just one of those guys that do everything in Excel, Calc now. Never really see the need for Access or Base unless you need to do reports or setup data entry for others.
I have a lot of experience with MS Access, but have moved to daily driving Linux for over a year, so let go of MS Office. I never realised how similar Base was to Access's flow. This is yet another notch in the belt for me never have to go back to the Microsoft ecosystem, but still being able to build cross platform applications. It doesn't really have an equivalent to VBA but still small database applications can easily be built agnostic to the OS of the PC. Thanks for a great video.
LibreOffice offers a Python scripting API. Python is a bit more advanced than VBA.
@@lawrencedoliveiro9104 even better
Hi! Ludite here. I've been using Memento Database for years now. I use it mainly for storage of records for my business, but ultimately, at the end of each job, I need to generate reports which has been painfully tedious for me. And the forum is hit or miss: they clearly hate ludites. This video was helpful to me and I would very much appreciate more database content.
Thank you for making this video. When I did my GCSEs 20+ years ago I used Microsoft Office and the database work is the part that I have the poorest recollection - probably because of the amount of preparatory work involved in databases vs the ready-to-work aspect of wordprocessor and spreadsheet software. As far as I now remember, there is quite a lot of overlap between this workflow and that on Office '97.
I love LibreOffice. I've been using it for a few years now.
Really good presentation. The wall I hit when studying sql databases was joins... It takes memorization to know which join command(s) to use properly in a query. But with applications like MS Access, or Libre Base you don't have to know those commands, just the logic of the data connections. Thanks for another great video.
I don’t memorize (much). I keep a link to the online docs in my browser bookmarks.
Aloha, Chris. This was fantastic. It had never occurred to me to use a database in my work, but after watching your presentation I can say I will be changing that. I appreciate, yet again, the time and effort you put into these weekly videos. Mahalo.
This channel has taught me much needed skills in computing, thanks again
Thanks for your support, most appreciated. :)
An excellent introductory video for those of us who have never used database programs before. Thank you for the overview and presenting so much information in a friendly and comprehensive way. Be safe.
this is gold!! I needed this for my CS studies and you has saved my ass 🙏🏻
Great to hear. Good luck with your studies.
👏🏻 another alternatives videos of Office from Mr. Barnatt
Indeed!
well done EC, I learned more in your 30 minute vid, than in a bachelors level DB distance learning college course from 15 years ago..thanks for sharing the knowledge!
Wow, nice intro to databases. Looking forward to your next video!
Thanks Perry. :)
Thank you for this video. I knew that there was a database in LibreOffice, but I didn't realise it was so comprehensive.
FOSS software usually suffers from UX due to not having Designers contributing from the start. Quite unfortunate if you ask me.
May be useful in the future - I haven't felt the need for a database yet. If and when I do, I'll probably have to watch this several times as I did not find it either simple or straightforward! 😆
Nice one, particularly as you've given a nod to forms; a factor generally omitted in most tuts. Cheers Chris
Thanks Peter.
WOW! My head is spinning. LOTS packed into half an hour. All good and very interesting. Now I need to make a list of time points in the vid so that I can refer to each concept to allow me to move forward with the learning process. Maybe I should create a database about each little segment of the vid - LOL.
Thanks for this. The video has labelled chapters if you hover over the progress bar at the bottom. Or you can see the chapters and timestamps listed at the end of the video description.
If you're actually curious, the list box bound column is defaulted to 1 because it assumes you don't want to bind to the first column, usually the ID column, which is usually just an uninformative autonumber value in most tables. Picking from a list of IDs isn't helpful compared to picking from a more informative column, like name or model or something.
Ah, of course. This makes sense.
It is common in UI selections to show a list of descriptive values to the user, but to store unique IDs for each option in the backend, and use those to represent the actual selection that was made.
Thanks💝 for this tutorial. I'm tired of searching for this database tutorial using libreoffice base which may be easy to start to learn instead of Querying database tutorial. And your explanation starting with the applications of learning databases is awesome🤩 idea which stimulates the user to learn this lesson. I request you to do more videos regarding this.
It is basically IBM SPSS alternative. This is very useful for Data Analysis.
Great video, well-explained. I don't work with databases very frequently, but I always enjoy it when I do.
Hi Chris. :)
I don't usually post on computer related sites, but I actually have many years working in information technology and services, even going back to the days of 16bit windows, close to inception of the first Linux distro's as well hardware as old as 8088 and 8080 XT PCs and micro computers. The content that you Sir, have on every video that I have ever viewed on your channel has ALWAYS been top professional produced content towards Linux, applications and affordable computing options. The UA-cam community as a whole is really lucky to have you. I like to wish you and yours all the best this holiday season and a great new year! - MrTom
Thanks Mr Tom. :)
You are Welcome. Happy holidays.. all the best!
Another amazing tutorial video Christopher B. Hope you had an amazing week ! Cheers !
You can do as many as you like of this kind of video! I love it, love the instructions, love the use of LibreOffice. And I would very happily watch more detailed videos and use of LibreOffice Base/Calc etc
Thanks for this, most appreciated. :)
I forgot to say that I did a 3-part series on spreadsheets (using OpenOffice, so works in LibreOffice) a few years back:
Starts here:
ua-cam.com/video/7Q2C9MB-YH4/v-deo.html
then
ua-cam.com/video/Pm_raXxS8u8/v-deo.html
then
ua-cam.com/video/iFz82q4vHnk/v-deo.html
@@ExplainingComputers Bluddi fantastic links/guides! Thank you
Can’t say this video is for me, since I work with databases, but it’s important to have good tutorials out there, so take my upvote!
Thanks Chris. I have wanted to create a database of all my physical music for a long time. The goal is to find a track easily if I get a request from a listener on my radio show. I think I will give it a go now. There will be a lot of typing involved so it's going to be a winter project.
Sounds like a good project. Do keep backups! :)
If the physical music includes CD, then you can save some typing by referencing CDDB, an open database of CD information based on the CD ID. I don't know how it works but backing up my media using "ripper" programs has them pick up the right information automatically. Mostly. Other times you edit the details.
An alternative is to scan the EAN/GTIN barcode and pull the information off the WWW.
Thanks so much Chris, I have a job for this application now. I will refer to this video to help me out.😊
Good luck! :)
just found your channel a few days ago and really enjoy your content
Welcome aboard!
This will come in handy while cleaning my parent's garage :) You always explain things in a humanly understandable way.
Thank you for the awesome introduction, Mr. Barnatt!