movie database

This code imports data from IMDb TSV files (principals, titles, and names) and stores it in a structured SQLite database.

This code provides a set of functions for interacting with a SQLite database containing movie information, including methods for searching by Levenshtein distance and retrieving actor and title data. The functions use a mix of synchronous and asynchronous programming, with prepared statements and promise chains to improve security, performance, and readability.

The code initializes a SQLite database and defines a function dropTitles to drop indices and a table from the database. It also prepares a query to count the number of rows in the name table, but the result is not utilized.

This code searches for documents containing "express js" in the "books" index and "book" type within an Elasticsearch database.

This code sets up a SQLite database schema for storing IMDb movie data, including tables for movies, actors, titles, crew, and episodes, along with indexes to optimize data retrieval.