Prof. Dr. Jens Dittrich, Big Data Analytics

Пікірлер

@seonwookim9595 7 сағат бұрын

Sir thie is pure gem. I wonder if we(students like me from youtube) will ever have a change to see the code that you share on the videos.

@jensdit 6 сағат бұрын

We just started with the PythonDB in September 2024. My goal is to open source it soonish... stay tuned.

@hoots187 Күн бұрын

danke

@scorcism. 2 күн бұрын

great

@sschwarz2084 6 күн бұрын

4:32 für später zum Weitergucken :)

@hoots187 8 күн бұрын

babe new german guy talking databases video dropped

@knkootbaoat6759 12 күн бұрын

Well said 13:40. Actually idk if well said (because I don't have the same expertise as you to make that claim yet) But the general idea of actually understanding HOW exactly a 'product' work is generally good (obviously an issue is that it takes time to understand how complex products work and it takes time to become knowledgeable enough to make a 'fair' opinion)

@jensdit 12 күн бұрын

My point is that these shitty "explanations" on web sites are often an indicator for questionable technology. It is not hard to explain ideas conceptually, in particular in data management. Then you should see sentences like "The core idea of our approach is ... Existing DBMSs have the problem that .... In contrast to DBMSs, .... We leverage the following existing techniques from data management, however in contrast to how a DBMS uses these techniques, we. ... In more detail, what we do technically ... Here is an example use-case showing how to handle it with an existing DBMS vs with our technology etc. etc. etc." This is not the case for the example I am showing (one out of many in that space).

@hoots187 12 күн бұрын

@@jensdit thanks for these videos and for replying, it is much appreciated!

@erisboxxx 14 күн бұрын

“I never intended to be in databases but here I am” …building and maintaining the most used database in the world. Lol

@mikewurlitzer5217 16 күн бұрын

I'm just an insignificant user of SQLite with a GAMBAS front end and appreciate the ease and blazing speed of SQLite. My only issue, and I realize again it would insignificant, if this is just a single file, why cannot two people share it while it resides on a NAS? I have 2 Linux Mint laptops which can read but not write to a SQLite DB on a NAS. I have a finance and inventory program which I wrote to address my needs 100% but without the ability to share via a NAS, no matter what I do with permissions it just becomes a single user program.

@Graveness4920 19 күн бұрын

Thank you for uploading this amazing video! I have a question: What happens if a transaction makes numerous changes and the file size limit of the WAL (Write-Ahead Logging) files is exceeded before the transaction can be committed? Does SQLite abort the transaction? It seems that merging the WAL back into the main database wouldn’t be the appropriate solution in such a case.

@jesusruiz4073 18 күн бұрын

The file size limit of the WAL (with 4K pages) is around 17TB. In general, you should not let the WAL reach this limit before a checkpoint. In addition, you probably have exceeded the size of your physical disk.

@bjarnenilsson80 19 күн бұрын

Sorry if this is slightly ot but the "I gotva bug report because my application puped up the error messege" problem might be solved if the error was a bit more verbise, for instance " Database connection failed, , Host could not be resolved" , or " Database connection failed, connectione refused /timed out" in thise cases when the error dropped into the laps of the on sire/outsorced support at your consumers, they would probably be able to see that ther netwok/firewalk erc had a problem and direct theticket to the right person insted of you bacuese in most cases i bet the issue wasn't really your application . This is something that annoys me on the other side, I would like to be abke to give support some useful info without combing through logs. Or in some cases give myself a chance to debug the issue ie is my local resolver aple to resolve the hostname or not. Eactually include the histmae/ip in the error message thst way i can at keast se if i have conectibity to the hist or jf the problem is somwhere between me and the db server/loadbakancer

@AlexeiAnisimov 19 күн бұрын

KISS at it's best 👏 so cool

@ChristianCK-k8o 20 күн бұрын

Dieses Fach macht mich fertig, vielen Dank für das Video :D

@jensdit 14 күн бұрын

😂

@hoots187 20 күн бұрын

thanks coach for the videos 🫡

@enesdemirtas2916 22 күн бұрын

Hello Professor, Could you briefly explain the answer of the assignment at 1:24:15, please? Have a nice day.

@hansjzeller 22 күн бұрын

Thanks, great talk! I've worked on the "other" databases for my entire work life and I really appreciate the core message of the talk: Avoid complexity - if possible. That's true both for the code as well as for the number of dependencies. Looks like SQLite reduces complexity for both of these very well. I also like the statement about support until 2050. Even if that's not a guarantee, of course, it shows the long-term thinking of the developers. Great to see how this kind of design and philosophy is very successful.

@codingwithjamal 25 күн бұрын

Great talk, learned a lot

@tomcole112 26 күн бұрын

It’s an uninteresting nit-pick, but FirebirdSQL also aspires to be in the exact same space as SQLite in terms of being an embedded database that works in process. It obscures this by offering a client/server variant that grafts a network protocol on an embedded instance running in a second server, and attempting to use system file locking semantics to support transactions between competing embedded users. Obviously, compared to SQLite, the impact/importants of Firebird is negligible. I only mention it because I briefly worked with Firebird about 15 years ago and found the development team to be largely wonderful, but the source code a ghastly collection of C++ code that was migrated from pure C, with exactly the set of issues you’d expect from such a thing…

@hstrinzel 26 күн бұрын

I am using the emClient Email Client on Windows. That supposedly USES SQLITE, but it has MANY files, and I have never figured out how to access that data with any version of SQLite. Does anyone know?

@charliegnu 26 күн бұрын

If you have bash installed (you get it if you install git) you can run `file *` to check the format of each file (regardless of file extension). Sqlite files should show up. If they don't then the program is doing some kind of encryption to them.

@prashlovessamosa 27 күн бұрын

great lec thanks for sharing.

@bradgaragan4848 Ай бұрын

Jigabytes 😭

@Zensi123 Ай бұрын

thanks for sharing!

@Siavash_Alaee Ай бұрын

vielen Dank

@seonwookim9595 Ай бұрын

Theories with code, great lecture as always. Hope the world can have more professors like him, so that we can learn useful stuff with fun.

@luqmansen Ай бұрын

Watched the prev videos, this one is more elaborate. Thanks!

@seonwookim9595 Ай бұрын

thank you so much for the great content

@kmio1622 Ай бұрын

schön, sich als mich ausgeben. hinter meinem notebuach

@FineWine-v4.0 2 ай бұрын

I wonder what people will think about Fossil Which is a complete alternative to Git created by Richard Hipp

@maddelasaikarthik7563 2 ай бұрын

Can you share the course link ?

@HomeEngineer-wm5fg 2 ай бұрын

What a gem of a presentation!

@jibbscat5146 2 ай бұрын

❤

@shalempanthagani6034 2 ай бұрын

I wouldn't have clearly understood if there were no examples, gotta appreciate the efforts of re-explaining things.

@Felistig 2 ай бұрын

Ich glaub mein LK Lehrer hat Ihr Video als Material für die Stunden verwendet Lol

@stuffzoom 2 ай бұрын

Man! Great times to be alive!!

@FAYZER0 2 ай бұрын

Thank you, I was working on a 7 bit encoding exercise and the explanation for it seemed needlessly obtuse. This was very straight-forward.

@brandonh2690 2 ай бұрын

Pull request accepted!

@Anas01-c4s 2 ай бұрын

i think in raid 01 if one disk is failing the whole raid 0 config is lost, in this video you said that it depends on which disk in the other config is lost which i think is wrong ?

@jensdit 2 ай бұрын

The naming of raid levels is not uniform in literature: sometimes 10 (bottom up naming, like in my video) is called raid 01 (top-down naming). I use the former naming in my video. Raid 10: n replicas per each of the k stripes, here k=n=2 => In general, for each replica of each stripe you may lose up to n-1 replicas and you can still reconstruct all data. So with n replicas for each of the k stripes you may lose in the best case up to k*(n-1) disks and you can still reconstruct the data (if it is the "right" disks you are losing). In the worst case, you lose all n replicas of any stripe and you cannot reconstruct all data.

@Anas01-c4s 2 ай бұрын

@@jensdit you're talking about raid 10 and you're right, but i was referring to raid 01 (bottom up as ur video) so in the raid 0 config if you lose one drive the whole raid 0 config is lost, in ur video u said that if you lose one drive in the raid 0 (bottom) it depends on which drives you lost on the other raid 0 configs which i think its not accurate, because as per my understanding losing one drive in the raid 01 config renders the whole drives useless. Thanks for replying btw and u can correct me if im mistaken

@LuluVayne 3 ай бұрын

Dankeschön

@whatthefunction9140 3 ай бұрын

Just a matter of time before oracle takes this over

@VV0RK 2 ай бұрын

lol lmao

@judef 22 күн бұрын

lol in what universe

@gustavosuarez7945 3 ай бұрын

This is pure gold. Thanks a lot for sharing this.

@outwithrealitytoo 4 ай бұрын

Data Systems Architecture 101; Database Design 101; Copyright Issues with FOSS 101; Using Databases 101; Software Design 101; Why Algorithms Matter 101; Compiler Design 101- in an hour and a half... OK, perhaps rather then the full course it is a slightly odd combination of revision and "what will we be learning next term" but fundamentally a reminder of why Computer Science is a thing beyond general maths, engineering and informatics. I'd get interviewees to watch this as prep, and then ask them what they found interesting and why. If they only watched half of it because they thought it was boring, or beleive they knew it all, then I'd chase them out with a stick.