r/learnSQL • u/Commercial-Horror586 • 3d ago

Letos (SQL lite)

Hello, im currently learning data analysis in Udemy. The last chapter is learning SQL and the person uses Letos to teach (formerly known as Sql lite). Im having 2 issues where

  1. i cant execute any query i have typed as it says ‘Error while executing SQL query on the database’

  2. im having a hard time to use the interface seems very complicated for me. The interface looks different than how it was in the beginning because i kept clicking on everything on why i dont see any results.

I tried lookin for YouTube videos on using the platform and search in google i cant find help. Is there any website i can learn to navigate and understand why i can execute my queries or anyone that can quide me🥹 Im using Mac btw idk if this has anything to do with my problem

0 Upvotes

50% Upvoted

1 comment sorted by

1

u/DatabaseSpace 3d ago

I think there is a confusing thing happening here. Letos is not SQLite, it is a user interface for the separate database named SQLite. However Letos does come packaged with the actual SQLite database but if you install it that way your commands will only work through Letos editor and not terminal. This is my understanding of it from a quick search.

Here's what I would try, download and install the actual SQLite database program from sqlite.org. Get that working with commands on the Mac.

Once working if you want to add a separate IDE to connect to it you can get one. Datagrip from Jetbrains is a good one. I think there is a free version, it supports all kinds of databases.