This is singlehandedly one of the best tutorial series I have watched, thank you so much for your knowledge and your time. Quite literally exactly what I needed and the way you explain things is both concise and thorough. I like your voice btw, had a look at your channel, nice thumbnails too! subscribed and keep it up :]
@@MainlyWebStuff yea i had new ubuntu or something famous like that in front of me where it didnt worked, but actually then i tried and it worked everywhere else
SQLite is fairly primitive, and so it doesn't support many data types, like Date/Time. However you could probably get around this with a TEXT field, or a much more janky (and much more funni) approach, where you have a seperate integer field for each day/month/year.
Hi, I struggling with two elements of SQLite (1) I am trying to search for keywords within a column in a table (2) I am trying to search between a set of geographic coordinates (so between a range of two numbers) in a second column within the same table. If you have a method for these queries that would be really appreciated. Thank you!
How do you get that tabular / columnar view? By default, I get a giant run-on string with pipes (|) for delimiters. It's very ugly and difficult to read. EDIT: Ahaa!!! Brilliant! I found another of your videos where you detail how to do this by setting the '.mode'. Thanks! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YmW7LCnWrxY.html
Good day, I have a problem in the terminal I put dotnet and does not work, I need to use this directory cd /usr/local/share/dotnet/x64/. then I can see if this sdk is installed. But when I want to create a console the terminal show me this error message zsh: command not found: dotnet I tracking your steps to install this sdk
Thanks for your great playlist about DB browser and SQL lite. I wanted to know how to create a datawarehouse so adding a ETL engine , audit and logs and maybe a MDB, Do you have any relevant source ?
Deary me! Can you really 'see' your black command screen!? I wear glasses and still cannot see what you're doing! Please try and consider 'us' older folk with weak eye-sight.
If you have 4 pages open and split on the screen but then you make one of the pages full size on the screen then minimise it will the other 3 pages still be in order or do you have to re set them all up thanks
Oh my gosh I just spent 30 minutes manually adding data, didn't know I had to save the changes, and DB Browser crashed when I tried to run a test query. WHOOPS. Lesson learned. Thanks for the vid!