Wobbly Geekwooblygeek.hashnode.dev·Sep 16, 2023SQL Data CleaningLEFT Pulls a specified number of characters for each row starting from the beginning i.e. the left side. product_idproduct_name 1Apple iPhone 13 2Samsung Galaxy S21 3Google Pixel 6 SELECT product_id, LEFT(product_name, 3) AS abbreviated_na...DiscussLearn SQLWomenWhoTech
peternjuguna muniupeterandroid.hashnode.dev·Sep 13, 2023Mastering Data Storage in Android: SQLite, SharedPreferences, and File StorageIntroduction: In the world of Android app development, effectively managing data is paramount to creating functional and user-friendly applications. From user preferences and configuration settings to structured data, there are various mechanisms ava...DiscussSQLite
Mario Alberto Chávezmariochavez.hashnode.dev·Sep 1, 2023Full-text search with Rails and SQLiteToday, I planned to move a few small Ruby on Rails applications with Heroku using Kamal onto a single server. All applications use PostgreSQL as the database because it is simple to use with Heroku and because they take advantage of Postgres' full-te...DiscussSQLite
Wobbly Geekwooblygeek.hashnode.dev·Aug 30, 2023Combine All conceptsHere, we'll take a look at SAT across public schools in New York City. Data had one table and 6 columns as seen in the Schema. The data type is also specified. Inspecting the data We used the SELECT to find all the records FROM the schools_modified...DiscussLearn SQLSQLite
Wobbly Geekwooblygeek.hashnode.dev·Aug 28, 2023Aggregate FunctionsOne of the key features of SQL is its ability to perform aggregate functions and group data, allowing us to extract meaningful insights from large datasets. In this article, we'll dive into some of the most commonly used aggregate functions and explo...DiscussLearn SQL#SQLtutorial
Jyotirmoy Barmanjyotirmoy.dev·Aug 25, 2023SQLite 101SQLite is a lightweight, serverless, and self-contained relational database management system. It's often used in applications that need a local database. To perform basic queries in SQLite, you can use the SQL language. Installation To install SQLit...DiscussBackend-DevOpsSQL
Ihwanblog.ihwan.id·Aug 20, 2023Memilih Local Database terbaik untuk Flutter ProjectDewasa ini, tidak bisa dipungkiri jika penggunaan local database / storage pada mobile apps masih diperlukan seperti untuk menyimpan data pada offline mode atau sekedar caching response dari api. Berikut kita bahas Local Database populer yang mungkin...DiscussDatabases
Wobbly Geekwooblygeek.hashnode.dev·Aug 20, 2023Using the ORDER BY Statement to Sort Query ResultsIntroduction The ORDER BY statement allows us to arrange query results in a specific order based on one or more columns. Therefore, we can present data in a more structured manner. Syntax: SELECT * FROM table ORDER BY column Here, table refers to th...DiscussLearn SQLSQL
Wobbly Geekwooblygeek.hashnode.dev·Aug 14, 2023Using SQL Online IDEFor our practice, we'll be using the Online IDE you can code along. Here is a simple guideline for uploading your files On Your browser search SQL ONLINE IDE Here is how the page looks like On the left side, you can see the different SQL flavor...DiscussLearn SQLSQL
Hooman PegahmehrforApplication Supportappsupport.academy·Aug 9, 2023Tiny PowerShell Project 7 - SQLite & CRUDAlthough we can download and install System.Data.SQLite .NEt provider, load the libraries, and go about using SQLite that way, PSSQLite module exists for interacting with SQLite databases without having to deal with .NET classes. Here's how to use PS...Discuss·1 likeTiny PowerShell ProjectsPowershell