gagan7995
Please tell me how to write a query for this in nodejs
API 4
Path:
/user/following/
Method:
GET
Description:
Returns the list of all names of people whom the user follows
Response
[
{
“name”: “Narendra Modi”
},
…
]
Tables:
User Table
| Column | Type |
|---|---|
| user_id | INTEGER |
| name | TEXT |
| username | TEXT |
| password | TEXT |
| gender | TEXT |
Follower Table
| Column | Type |
|---|---|
| follower_id | INTEGER |
| follower_user_id | INTEGER |
| following_user_id | INTEGER |
Here, if user1 follows user2 then,
follower_user_id
is the user ID of user1 and
following_user_id
is the user ID of user2.
Most Liked
gagan7995
Sir I’m using Node js
Given an
app.js
file and a database file
twitterClone.db
consisting of five tables
user
,
follower
,
tweet
,
reply
, and
like
.
Write APIs to perform operations on the tables
user
,
follower
,
tweet
,
reply
, and
like
containing the following columns,
User Table
| Column | Type |
|---|---|
| user_id | INTEGER |
| name | TEXT |
| username | TEXT |
| password | TEXT |
| gender | TEXT |
Follower Table
| Column | Type |
|---|---|
| follower_id | INTEGER |
| follower_user_id | INTEGER |
| following_user_id | INTEGER |
Here, if user1 follows user2 then,
follower_user_id
is the user ID of user1 and
following_user_id
is the user ID of user2.
Tweet Table
| Column | Type |
|---|---|
| tweet_id | INTEGER |
| tweet | TEXT |
| user_id | INTEGER |
| date_time | DATETIME |
Reply Table
| Column | Type |
|---|---|
| reply_id | INTEGER |
| tweet_id | INTEGER |
| reply | TEXT |
| user_id | INTEGER |
| date_time | DATETIME |
Like Table
| Column | Type |
|---|---|
| like_id | INTEGER |
| tweet_id | INTEGER |
| user_id | INTEGER |
| date_time | DATETIME |
Sample Valid User Credentials
Sir I unable to perform the sql qurery for this can you help me
AstonJ
Hey Gaganpreet, welcome 
Your post was missing some context - what language/framework are you using etc? If you can add some more info that would help others get more of an idea of what you’re after 
OvermindDL1
You are still missing information, like what format the *.db file is, what connector library you are using to access it, etc… etc…
Popular Backend topics
Other popular topics
Sponsor Spotlight
Publishing Linux Magazine, ADMIN, and MakerSpace for 25+ years.
Latest in Node.js
Backend>Questions
Categories:
Sub Categories:
Popular Portals
- /elixir
- /rust
- /wasm
- /ruby
- /erlang
- /phoenix
- /keyboards
- /python
- /js
- /rails
- /security
- /go
- /swift
- /vim
- /clojure
- /java
- /emacs
- /haskell
- /typescript
- /svelte
- /onivim
- /kotlin
- /c-plus-plus
- /crystal
- /tailwind
- /react
- /gleam
- /ocaml
- /flutter
- /elm
- /vscode
- /ash
- /html
- /deepseek
- /opensuse
- /zig
- /centos
- /php
- /scala
- /react-native
- /lisp
- /sublime-text
- /textmate
- /nixos
- /debian
- /agda
- /deno
- /django
- /kubuntu
- /arch-linux
- /nodejs
- /ubuntu
- /spring
- /revery
- /manjaro
- /julia
- /diversity
- /lua
- /markdown
- /laravel
Devtalk Sponsors
Practical resources that improve the lives of professional developers.
We build trusted fault-tolerant systems that scale to billions of users.
Real-time error tracking, performance insights, and observability for devs.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Develop your skills with books, videos, and courses.
Catch errors, track performance, monitor hosts and more.
Enabling companies to succeed by building software people love.
Courses that move you from confusion to "Aha, now I get it!"
Publishing Linux Magazine, ADMIN, and MakerSpace for 25+ years.