Good day to all

Any one can suggest to me. I have getting below error while executing the code in pycharm

Traceback (most recent call last): File "/home/rajasekar/Desktop/Proj/iy/app/.venv/db.py", line 19, in <module> O=Database("Customer.db") ^^^^^^^^^^^^^^^^^^^^^^^ File "/home/rajasekar/Desktop/Proj/iy/app/.venv/db.py", line 16, in __init__ self.cur.execute(sql) sqlite3.OperationalError: near "EXIST": syntax error Process finished with exit code 1

vsraj80: what you understood from the error?

Mohan: Hi. I think the py file not linked with db.

ohh i think i missed s in EXISTS. i will try again

can i post the code here to get support

hi all

i started learn REST API.

vsraj80: this channel is logged, so probably you should not share any code from official places (like office etc). only share the code which you own or Open source code.

i can't understand some technical terms

krishna: which term?

client server architecture

seperate a work?

it mean server process only request after send respone?

krishna: do you understand sockets?

krishna: heared about sockets?

i don't know sockets

may be better to read this documentation

mohan43u : thank you

and write a simple echo server and client, the echo server should return whatever message the client sends

the client should send whatever we type from standard input (terminal).

if you do this first, you will understand one of the basic building block about internet.

I would say very important build block of internet

mohan43u : okay bro

Mohan: sure. I will make try and publish in blog

one linux relevent doubt

/dev/shm -> this mount point is ram disk?

krishna: yes

vsraj80: try what? sockets?

mohan43u: how can i expand default size without use swap

krishna: which default size?

mohan43u : 1.9Gigabytes

mohan43u : why created this point in linux and how it use linux this point?

krishna: /dev/shm is the base for shared memory objects (man.archlinux.org/man/shm_overview.7) , so if you do multi-process communication using shared memory, this is the memory you will be operating.

mohan:i confused whether installed sqlite3 properly or not. so googling it.

vsraj80: what OS are you using?

as new to ubuntu i have struggling to all basic configurations

mohan:linux

hello all

Mohan:SQL error vsrajpython.wordpress.com/2025/01/30/sql-error

vsraj80: what is the tutorial you are following?

for connecting python and sqlite?

Shrini:tutorial means

tkinter

vsraj80: how are you learning this sqlite and python?

are you reading any documentation ?

or tutorial? or guide?

yes. youtube tutorial project

shalli share the link

dont follow youtube

read some tutorials

reading text is important

krishna: good to see your repo github.com/github-CS-krishna/TerminalTyping

can you make it for tamil typing too?

vsraj80: never ever goto youtube to learn any thing

The more you go away from reading text, you are going away from programming

Shrini: Okay. I then i will stop here the project

you can continue the project

just search for python/sqlite tutorial

do you know SQL>

?

Shrini: no

I am from Commerce background

I have struggling to codin in ubuntu too. But MK already advised me to learn with linux. so i have started

then start learning SQL first

yes, learning the basics are really important

most of the CS students learn the basics on college

and they can add on more skills on top of the basics

as you are from non CS, you have to invest more time on the basics

Shrini: fine. i will start

read this book fully and practise the code therw

do you suggest any link for sql

read all the lines

dont skip anything

Okay

you can start with this book, if you can read tamil

or start the tutorials from w3schools.com

what is the project you are trying?

desktop application for a computer service center

shrini: sorry i out of focus

shrini : okay i will implement tamil typing support

vsraj80:

tha

nks

vsraj80: can you explain your project idea?

are you running any computer service center?

or working there?

what is the requirment ?

thanks krishna

krishna: check this too

let me know if you can work on this

vsraj80: learn the linux basics too

Shrini: My friend running a Computer Sales center. On for him i have trying to create a desktop app. Already he have one msaccess application. but he facing some issue on that.

what that application should do?

Customer name,and contact details,and kind of issue like mother board problem,os installation , and . this will lika a job sheet. the work will be alloted to a service engineer.

ok

once laptop collected from customer job sheet should be given in pdf format to customer. then based on work status data will be updated like work completed,work pending, problem not solved so return like

interesting application

how much time you have to build this application?

i dont have idea. just blindly started.my target i have to complete it. thats all

Expecting ideas and suggestions from your end. till that i will proceed with that sql ebook

it may take 6 months for you to complete the application

or more

it will be a good learning experience

but, if your friend needs a quick solution, explore any existing web based ticketing systems

there are many Free/open source ticketing systems

ohh.ok

Not urgent. He will adjust.

ok

how many hours you can spend on learning, per day?

?

approx 4 hours

ok

start reading the MySQL book

take notes and publish the notes daily

you can take 3 weeks to complete the book

read, practise, take notes, blog them

Shrini: Sure, thank you

I will quit for the day

sure. thanks

hi annamalai

thanks for the GDB book reading hour at kanchilug

hi shrini-weechat

welcome. mainly it is being conducted as a means of proof reading and to improve the translation

Good day

Draft model vsrajpython.wordpress.com/2025/01/31/my-project-requirement