Dope Tech Episode 2

<<@alphaboy1980 says : Thank you, that was helpful.>> <<@manik28th says : Excellent video, thanks mate.>> <<@grantlewis8420 says : can I import a table from outside the database?>> <<@LibertyGarden says : Parting ways with Microsoft and their ever growing intrusions into privacy. Recently, I've started using Calc. However, I'm also looking for an Access replacement, Does Libre Base allow code modules? Thank you.>> <<@OmarKaddoura-h4m says : It defaults to one because of common use cases like inventory probably>> <<@ЯковН-ю9х says : 7:40 spaces in the field names? some folk say it is a big no no :(>> <<@CyclicCollective says : Gorgeous presentation sir. The last database worked on had 770 tables with half a million code lines but I am now retired and my home hobby inventory database will probably have 6 tables, 10 at most so this tool should do the job, plus I can give it to friends and they don't need to spend money on anything since Libre runs on everything. Base looks a lot like MS Access which was quite good but terribly poorly used by users who instead preferred to use Excel for every kind of database. I suspect, perhaps, that the reason the interface defaults to one rather than zero for sub-forms is that old database geeks, like me, often have a hidden numeric surrogate key at position 0. I almost never use an identity or a foreign key that is anything other than a generated integer as users have and insufferable tendency to want to change the text of anything that they see on the screen. Again, a great job sir, without going int too much detail.>> <<@ynyslochtyn says : You have shown us how to create a new database creating an .ODB file. If you have an existing .dbf file (the universal gold standard before paradox or access) it can neither connect to or import .dbf files making this database program about as useful as a chocolate teapot? If you want to work with databases, I would suggest lazarus would be much your best bet.>> <<@Randy-m7h8s says : Excellent presentation! This may generate more interest considering the current move away from Microsoft to Linux. Now if we just had a visual development language like C# to access the database.>> <<@riochndr says : I was exploring libre office and found "LibreOffice Base". I've been workin on Database like Mysql and Postgresql to create web application, so every decision always fall into web development because of lack of my knowledge. But this, this is a simple solution for simple problem. I love your clear and slow instruction. Thank you>> <<@MyOtherHead says : I learnt more in this 30 minute tutorial, than the 6-8 hours I spent doing a SQL free online microcredential through a state government vocational college (NSW TAFE), and a few hours more reading about Base in the LibreOffice Docs. Thanks, Chris, you got me off to a start, and one step closer to my objective. Though to be fair, the online course gave me a good grounding in the RDBMS ecosphere.>> <<@user-ml9kd5jw7c says : Thanks>> <<@peterkornos8749 says : for me is this too complex and complicated, I just don't catch it, and I really like to :-(>> <<@devanssivaram6080 says : Thanks a lot sir it helped me a lot from Class 10 cause I have practical tomorrow but I have a bit problem with forming query>> <<@frankmaeder4358 says : thanks for this Video! me being a hardcore MS Access user for 30 years, even creating a C/S Data Warehouse with millions of records in the maintable - hesitated now to migrate to Linux on my personal computer. Not bec. of documents, or spreadsheets, that sure can be handled. but bec. of the database..... until today. Again, thanks for making sure i now definitely will migrate.>> <<@vimalpratapsingh-g5f says : Class tenth student attendance here❤😊>> <<@spunkler7729 says : THANK YOU, SIR. I MANAGED TO GET FULL MARKS IN MY PRACTICALS>> <<@bikepacker9850 says : more explanation on primary Key would be appreciated. What is it and why do you need it?>> <<@jerrycornelius-v3y says : The word "relation" as in "relational" originally meant what we would call a table today. It did not at that time imply relationships between tables.>> <<@madametrafficjam8347 says : What if you WANT to be able to add new SOC entries on the form for each entry (or most of them)? How do you make it show up in both tables? I've established a relationship between two tables. Table 1 is book info and has a field for Author. Table 2 is author info and also has a field for Author. Added table 2 as a subform but it's not looking like your version. Instead I've got table 2 added as a miniature table on top of the fields from table 1. Adding information to the author field in table 1 doesn't change anything in table 2 and throws an error because the new value in table 1 has no match in table 2. I've been going slowly crazy with videos and tutorials trying to find a solution to this.>> <<@edwinfarr7301 says : Excellent video!>> <<@Snaerffer says : This is surely the best instructional video on this topic I’ve ver seen. You make it all understandable and I can now visualise how to create my own database … something I’ve been irritated about for many years. Thank you!>> <<@SheebaRajeev-x3n says : t>> <<@andreasalerno89 says : Very straightforward and pratical tutorial. Thank you. I'm going to to create a LibreOffice Database for a housewares store into a Linux PC, with legit Open Source softwares, no needs for Microsoft Access or Windows license.>> <<@Vallee152 says : When editing a form and I try to select a textbox, it will only let me multiselect it and the label. How are you able to select just the text boxes?>> <<@Vallee152 says : How do I make a list in a field? I'm trying to make it so an entry can point to arbitrarily many tables specified in a field.>> <<@carltaylor4942 says : Thank you, as always, for a really informative and well-presented tutorial. 😀👍>> <<@haydarfuel says : you're going little too fast, you can explain why we're doing that to make more gap than again this is a free content, my request may be too much>> <<@YizhouLu-nyush says : Excellent and well-structured explanation!>> <<@zoranstojanovski8407 says : I am supprise how good it is Libre Office Base. As more then 20 years programming in MS Access, I can say this is solid solution for those who use linux os. Great video.>> <<@alancritchley7736 says : Just found this tutorial and you have made databases sound straight forward. So I set off building one for our singing group. I created four tables then tried "Relationships", but immediately I got Error code -170. I do not know how to resolve this. What am I doing wrong?>> <<@Foll3tt3 says : Pleasant Morning, @ExplainingComputers Hope all is well. I have a small question regards to creating the report. Whist in the attempt to follow the step by step tutorial, I happened to have stumbled upon an issue. During the final steps of trying to create the report with the wizard, instead of it being generated in the writer, it is generating the report builder instead that looks rather alien to me. Is there a way to setup LibreOffice Base so that it builds the report in the writer instead of the report builder?>> <<@DilaYaraman says : 14:07 I use mac and I don't see replace with button. what should I do ?>> <<@andrewmitchell3289 says : Thanks very much, great refresher for an old Access user.>> <<@theblackupgrade says : Don't know what databases do but I had to help my sister with her school project and we don't have Microsoft Access so this was very helpful. Thank you for your time Sir.>> <<@oscardominguez6491 says : Great video, great teacher, thank you.>> <<@deborahpattie4570 says : Great overview!!>> <<@bradkevin4209 says : Please introduce maple and spss free alternatives on linux ' if there is any . Thank you>> <<@T_O_L_ says : Fantastic tutorial. Very concise and to the point. Thank you very much for your work and effort to help provide understanding of the program to get started. Cheers mate.>> <<@tomholbrook2216 says : Hello - I have been following you for a long time. Question: I have a raspberry Pi 5 with M.2 hat drive card/hat attached. Boots from SD drive just fine (thanks from previous video). I am having difficulty getting Java JRE to run so I can run Librebase on linux Ubuntu 24.04.1 LTS. I run this in a terminal: java -version. I get: open jdk version "21.0.5" 2014-10-15 . Any ideas?>> <<@HarriNousiainen-s3k says : Absolutely fantasticst😊>> <<@stevereynolds5899 says : Thank you for preparing this. However, what I want is a normalized database where data elements are not stored in duplicate/triplicate etc., which your design does with the Processor Type 'SoC' field. Your example links the tables by the text field 'SoC' which gets populated N times (once for every Computer record), making it impossible to change the SoC field text should that ever be desirable. A normalized DB (I'm sure you know this) would use a unique key instead of the value SoC, the key pointing to the text value SoC which could then be changed at will and all affected Computer records would then display the updated value. I haven't yet found out how to do this in a Base form, but I'm sure there is a way. But, you got me started on a good footing, thank you. Update : The listbox can be configured to display a text value from a table and return an index key that gets stored in the file referencing the table. See this link https://ask.libreoffice.org/t/update-record-with-listbox-selection/24056/14>> <<@davidkachel says : Well done, indeed. From a 20 year FIlemaker solution programmer.>> <<@Charlie-eq3dj says : I cannot get the list box to work. Has anyone else run into this issue if you followed this tutorial? Have you found the fix to get it to display the contents of the table in the list box?>> <<@rmcellig says : Excellent video!!! I need to setup a database of my music collection. Should I keep it flat file or relational? Any ideas links? Thanks again!!>> <<@Peter-cd3us says : 9 = StarFive JH7110 RISC-V 4 x 1.5GHz U74 Imagination BXE-4-32 8= StarFive JH7100 RISC-V 2 x 1.0GHz U74 H265/H262/JPEG codec subsystem 7= Rockchip RK3399 ARM 2 x 2.0GHz A72 & 4 x 1.5GHz A53 Mali-T864 6= Rockchip RK3588 ARM 4 x 2.4GHz A76 & 4 x 1.8GHz A55 Mali-G610 MP4 5= Intel Celeron N5105 x86 Quad core 2.0GHz base, 2.9GHz burst Intel UHD Graphics 4= Intel Celeron J4105 x86 Quad core 1.5GHz base, 2.5GHz burst Intel UHD Graphics 600 3= Broadcom BCM2711 ARM 4 x 1.5GHz A72 VideoCore VI 2= Allwinner D1 RISC=V 1.0GHz T-Head Xuantie C906 G2D 1= Amlogic S905X3 ARM 4 x 2.0GHz A55 Mali-G31 MP2>> <<@johnnyrosenberg9522 says : Nice! I never bothered with Base, maybe I'll give it a try now.>> <<@shannonv_66 says : Thank you sir, in all the videos I had watched, only yours that made me understand the libreoffice base. May god bless you.>> <<@robertblodgett3911 says : 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.>> <<@jnjtm6113 says : All your videos are gold>>