Hi Cedric, I'm not sure if this is directly applicable, but you might get a feel for how Kafka relates to more traditional databases from this post (afaik this is one of the seminal talks relating the two ideas): https://www.confluent.io/blog/turning-the-database-inside-out-with-apache-samza/
You can think of Kafka as a durable record of updates to the database, but not a full view of the current database state itself. Kafka would be a reliable place to store events that you want to record in multiple places, and you could then add a processor for these events (ie Kafka Streams or Samza) to actually update a database state from this event data. However, the events themselves are not the full database. I haven't explored ksqlDB at all; perhaps somebody familiar with it could weigh in here. Cheers, Malcolm McFarland Cavulus On Thu, Sep 3, 2020 at 12:58 AM Gaurav Bajaj <gauravhba...@gmail.com> wrote: > Hello Cedric, > > My 2 cents : > > We use Kafka alot but mostly for messaging and event streaming purpose. > Using Kafka as Database is not a usecase i would look Kafka for. Ofcourse > you can use it to store some intermediate states but having it as "system > of records" would be stretched use case for Kafka. > > Best Regards, > Gaurav > > On Wed, Sep 2, 2020, 9:31 PM cedric sende lubuele < > sende.ced...@hotmail.com> > wrote: > > > Let me introduce myself, my name is Cedric and I am a network engineer > > passionate about new technologies and as part of my new activity, I am > > interested in Big Data. Currently, I live in Africa (Congo) and as > everyone > > knows, Africa is very late in terms of IT infrastructure (the Cloud is > > difficult, we work a lot on premise). > > > > While doing some research, I came across Kai Waehner's article (Kafka > > replace database?< > > > https://www.kai-waehner.de/blog/2020/03/12/can-apache-kafka-replace-database-acid-storage-%20transactions-sql-nosql-data-lake%20/ > >) > > and I would like to be able to get an idea about the possibilities of > Kafka. > > > > Let me explain, I am working on a project for integrating several > > databases (MySQL, MongoDB, Neo4j, ...) and I have to develop with my > team, > > an alert system which must detect anomalies on different criteria linked > to > > a person in the various departments of the company. > > Would Kafka be a good solution in order to centralize all the data and > > create several analysis scripts to detect an anomaly and send back an > alert > > message such as for example a suspect wanted by the police? > > > > Thank you in advance > > > > > > > > Sende Cedric / Network IT > > sende.ced...@hotmail.com<mailto:sende.ced...@hotmail.com> / 082/8446954 > > > > UPSAIL GROUP > > http://upsail.co/<https://htmlsig.com/t/000001BFBBXF> > > > > [http://upsail.co/wp-content/themes/upsail/images/logo.png] > > >
