![techsapphire](/img/default-banner.jpg)
- Видео 178
- Просмотров 2 892 948
techsapphire
Добавлен 5 дек 2011
Techsapphire provides you complete business automation solutions.
We collaborate with our clients to help them meet their business goals with ease by providing them with the latest and outstanding software solutions. Our company is a one stop technology startup providing services around the globe. Our experienced and expert team works according to our clients’ needs and demands.
We offer :-
Point Of Sale (POS) System Development on web, mobile and windows platform.
Hardware device integration such as printers, scanners & POS like credit card etc with websites.
Ad hoc database services, like
Data modeling
Performance optimization
Integration services
Custom web solutions, like
Mobile App development
Website development
Data recovery and much more
Our expertise lies in cloud data technologies. Over the period of time, our services resulted in our clients making huge profits in terms of revenues and customers.
We are available 24/7 for our clients.
We collaborate with our clients to help them meet their business goals with ease by providing them with the latest and outstanding software solutions. Our company is a one stop technology startup providing services around the globe. Our experienced and expert team works according to our clients’ needs and demands.
We offer :-
Point Of Sale (POS) System Development on web, mobile and windows platform.
Hardware device integration such as printers, scanners & POS like credit card etc with websites.
Ad hoc database services, like
Data modeling
Performance optimization
Integration services
Custom web solutions, like
Mobile App development
Website development
Data recovery and much more
Our expertise lies in cloud data technologies. Over the period of time, our services resulted in our clients making huge profits in terms of revenues and customers.
We are available 24/7 for our clients.
Document similarity in SQL Server and PostgreSQL using cosine similarity
Document similarity in SQL Server and PostgreSQL using cosine similarity.
Script: github.com/yogimehla/AdhocScripts/blob/main/Similarity.sql
Script: github.com/yogimehla/AdhocScripts/blob/main/Similarity.sql
Просмотров: 115
Видео
Create stable AI agents for research using Langchain
Просмотров 2532 месяца назад
In this example, we will use three AI agents: Manager Researcher Example Generator We will provide a prompt to the Manager Agent to break down the information into topics. The Researcher Agent will conduct detailed research on each topic. The Example Generator will create and write examples for each topic, which will be stored in the example folder.
Convert SQL Server Stored Procedure into Postgres function using AI Automatically
Просмотров 1982 месяца назад
In this tutorial, we demonstrate how to leverage the power of AI and LangChain to seamlessly convert SQL Server stored procedures into PostgreSQL functions. Join us as we explore innovative techniques and tools that simplify this complex transformation process, making it easier and more efficient.
Devika AI vs OpenDevin your personal virtual employee
Просмотров 6442 месяца назад
Note: On Windows environment OpenDevin is better suited. Imagine you are having an free employee of your own, you can build apps with it and make money :D OpenAI API is used in this integration with google as search engine. Prompt used in the video: I want to create TechsapphireAgent and folder, which will do outbound calls using local text-to-voice package for response and start with opening a...
SQL Server to Postgres data migration using Trino
Просмотров 73010 месяцев назад
This video demonstrate data migration between sql server and postgres using ANSI SQL. Tool used in the videos are: Trino dbeaver SSMS SQL Server Postgres
Topics to learn for data architect profile
Просмотров 156Год назад
If someone wants to change there profile to data architect, then they should know these topics as it will allow them to know best tool for their data. #shorts
Semantic search in SQL Server using wordnet
Просмотров 1,6 тыс.Год назад
Semantic search help you search things with more meaning to them. By default, SQL Server semantic search is not easy and flexible to use. I am using wordnet dictionary to provide more meanings to searches. Download source code from: techsapphire.net/semantic-search-in-sql-server-using-word-net/
SQL Server Graph Table schema design, migration and performance
Просмотров 3,7 тыс.Год назад
SQL Server Graph Table is very good option to maintain application like social media. This video covers in depth explanation about graph table and answers: How we can design schema using Graph table? Benefits of using Graph table Performance Advance queries on graph table
Implementing Row Level Security on SQL Server
Просмотров 6 тыс.Год назад
Implementing row level security become very important if you are using SQL Server as warehouse or implementing multi tenancy.
Thermal print using react native
Просмотров 9 тыс.Год назад
This is demonstration of printing on thermal printer from react native
Creating video streaming app using flutter and webrtc
Просмотров 3,9 тыс.Год назад
Creating video streaming app using flutter and webrtc
Converting flutter design to react native
Просмотров 973Год назад
Converting flutter design to react native
Learn Apache Druid for Data Analytics part 1
Просмотров 7 тыс.Год назад
Learn Apache Druid for Data Analytics part 1
Chapter 6 Notifications using Firebase - II
Просмотров 134Год назад
Chapter 6 Notifications using Firebase - II
Chapter 7 Integrating Kotlin with Flutter
Просмотров 8212 года назад
Chapter 7 Integrating Kotlin with Flutter
Chapter 6 Flutter notifications using firebase
Просмотров 1742 года назад
Chapter 6 Flutter notifications using firebase
Chapter 5 Flutter row and column widget
Просмотров 442 года назад
Chapter 5 Flutter row and column widget
Chapter 3 flutter login screen and validation
Просмотров 3662 года назад
Chapter 3 flutter login screen and validation
Learn authorization roles and impersonate in sql server
Просмотров 1,6 тыс.2 года назад
Learn authorization roles and impersonate in sql server
Complete Extruded Cut feature in Solidworks
Просмотров 6 тыс.2 года назад
Complete Extruded Cut feature in Solidworks
Basic modelling in solidworks for beginners
Просмотров 542 года назад
Basic modelling in solidworks for beginners
Simple animation video in Blender for beginners
Просмотров 1112 года назад
Simple animation video in Blender for beginners
Programmer or IT employee should not invest in stocks
Просмотров 1802 года назад
Programmer or IT employee should not invest in stocks
Web Automation Testing Using Selenium Python part 6 Handling Auto suggestion
Просмотров 3972 года назад
Web Automation Testing Using Selenium Python part 6 Handling Auto suggestion
Web Automation Testing Using Selenium Python part 5 Handling Dropdown
Просмотров 4482 года назад
Web Automation Testing Using Selenium Python part 5 Handling Dropdown
Web Automation Testing Using Selenium Python part 4 Date Picker
Просмотров 8 тыс.2 года назад
Web Automation Testing Using Selenium Python part 4 Date Picker
Thank you very much, you saved my time!!!!
Thank you for wonderful guidance. Can you please share the script.
best explanation. thank you
Glad it was helpful!
How to write pm2 service for node red in windows 11 I m running an project on node red which should be alive but how to write pm2 service on windows
install pm2 in administrator mode, also you can add it on auto start.
I'm new in the subject and this video doesn't help me much.
Thank you for the feedback. This is not a common concept, but you can use whenever you have find similar data from database which are of big size or volume it too high. Thank you for sharing the feedback.
Hey, what's the best way to reach you?
yogesh.mehla@gmail.com or +91-9023262520
I have one naive doubt, I have a pyhton project, and have a virtual env for that, also I have the file that I want to run in my dag in that project, how to use the same venev for airflow? Or is there any other way using two different envs?
Hi, I need help, I need to convert flutter app to react native
Can I buy your script
Yes reach me at yogesh.mehla@gmail.com
But only tables are migrated, my views and store procedures are left out
check this ruclips.net/video/LSOef0FkjI4/видео.html
Thanks Yogesh bhai. Looks super interesting and gives a great starting point for further research and implementation.
Thank you :)
How it will work global website. It is not possible. It is just only for window machine
We have commercial solution for each platform. Kindly reach me at yogesh.mehla@gmail.com .
Hello Yogesh i need these utility please
Check video description. Also check ruclips.net/video/8z5bvF22iOA/видео.html
Awesome, just below excellent,
Thank you so much 😀
💯
Thank you.
Is there any way I can do this on my entire computer? I have failed uploads/downloads in games such as VRChat and also with my web browser, such as what was covered in this video. This did fix my problems I had downloading items off of my browser so Thank you very much :)
yes you can configure speed on router it self.
Still so useful after all these years, thank you!
Great to hear!
poor teaching sorry, your explaining is all over the place. slow down when you talk and cover individual topics before moving on.
Noted. I will soon release an updated and better version. I will try to improve.
Please share scripts
drive.google.com/file/d/1RUNgWj8BjQktVVVgklLITsoRV2j8KW1l/view
superset db upgrade is giving error for me!! plz help
not able to implement it for return
It's Awesome 👍..
Thank you! Cheers!
please can i get the source code
Hello Brother. Yes Kindly share me the scripts I will need them they will help me
kindly check video description. Also check latest video on migration using trino. ruclips.net/video/8z5bvF22iOA/видео.html
Can the app print stuff when running in background automatically? Almost like a print server ?
we have commercial for it.
can you please script to me
check description
I was trying to reach you and send you mail, let me know your availability.
What is username or password of Airflow?
Good day, After deploying a Windows Form Application the printer gives error "tmpPrint.print is denied". Thank you
Could you please do the same using react.js
yes kindly reach me at yogesh.mehla@gmail.com for commercial solution
I am trying to reproduce the same steps in my machine. I am not able to find Student table under Northwind database. Can you please where I can find the scripts for that? This video is starting to be very useful for me.
Will it support Ipad does this have app for I pad
yes but only network printer are supported.
what is the TCP custom protocall ? Please share the full info.
we are using custom protocol
The demonstrated platform responsiveness for ingesting just a few dummy records is absolutely disappointing. Also don’t really get what multiple comments like “wait for couple of minutes” has to do while you are presenting streaming solution claiming sub second operational processing !
Let me check where I can improve. But I will be doing a druid tutorial soon. Any suggestion will be appreciated and will consider them.
Hi, can I have source code?
check video description.
Thanks a lot Mister Techsapphire
You are welcome!
Good video, but the code is not clear. It would be nice if the code was uploaded to github or another sharing site.
Noted
Very informative and core knowledge for every level of SQL developer. Thank you
Glad it was helpful!
Thanku for video. can you share code. will be very thankufull
kindly check video description.
when I execute copy comments , I got this error "ERROR: invalid byte sequence for encoding "WIN1251": 0xff CONTEXT: COPY paymentmastervisa, line 1 " Can you help me ?
How to get the source code
kindly check video description.
Great! Can I access the code?
Hello, first of all, I would like to congratulate you. I couldn't open your codes.
check this and you don't need this tool ruclips.net/video/8z5bvF22iOA/видео.html
I need this script
SIMILAR CODE FROM CHATGPT Certainly! Here's an example code that demonstrates how to achieve inter-process communication using memory mapped files and event handlers in C#. This code assumes you have two Windows Forms projects: a sender project and a receiver project. Sender Project (Windows Forms): csharp Copy using System; using System.IO.MemoryMappedFiles; using System.Text; using System.Threading; using System.Windows.Forms; namespace SenderProject { public partial class SenderForm : Form { private MemoryMappedFile memoryMappedFile; private EventWaitHandle eventWaitHandle; public SenderForm() { InitializeComponent(); InitializeMemoryMappedFile(); } private void InitializeMemoryMappedFile() { memoryMappedFile = MemoryMappedFile.CreateOrOpen("MyMemoryMappedFile", 1000); eventWaitHandle = new EventWaitHandle(false, EventResetMode.AutoReset, "MyEvent"); } private void SendMessage(string message) { using (var accessor = memoryMappedFile.CreateViewAccessor()) { byte[] buffer = Encoding.ASCII.GetBytes(message); accessor.WriteArray(0, buffer, 0, buffer.Length); } eventWaitHandle.Set(); // Signal the event to notify the receiver } private void textBoxMessage_TextChanged(object sender, EventArgs e) { string message = textBoxMessage.Text; SendMessage(message); } } } Receiver Project (Windows Forms): csharp Copy using System; using System.IO.MemoryMappedFiles; using System.Text; using System.Threading; using System.Windows.Forms; namespace ReceiverProject { public partial class ReceiverForm : Form { private MemoryMappedFile memoryMappedFile; private EventWaitHandle eventWaitHandle; private Thread receiveThread; public ReceiverForm() { InitializeComponent(); InitializeMemoryMappedFile(); InitializeEventHandling(); } private void InitializeMemoryMappedFile() { memoryMappedFile = MemoryMappedFile.CreateOrOpen("MyMemoryMappedFile", 1000); eventWaitHandle = EventWaitHandle.OpenExisting("MyEvent"); } private void InitializeEventHandling() { receiveThread = new Thread(ReceiveMessage); receiveThread.Start(); } private void ReceiveMessage() { while (true) { eventWaitHandle.WaitOne(); // Wait for the event to be signaled using (var accessor = memoryMappedFile.CreateViewAccessor()) { byte[] buffer = new byte[1000]; accessor.ReadArray(0, buffer, 0, buffer.Length); string message = Encoding.ASCII.GetString(buffer).Trim('\0'); HandleMessage(message); } } } private void HandleMessage(string message) { // Invoke UI update on the main UI thread textBoxReceivedMessage.Invoke((MethodInvoker)delegate { textBoxReceivedMessage.Text = message; }); } } } In the sender project, you can create a Windows Forms application and add a TextBox control named textBoxMessage. Attach the textBoxMessage_TextChanged event handler to the TextChanged event of the textBoxMessage. In the receiver project, create another Windows Forms application and add a TextBox control named textBoxReceivedMessage.
Will it be worked if pdf as blob ?
yup
Thank you so much for sharing the knowledge. Best explanation for query optimization i have seen till now.
Glad it was helpful!
Can I get the code please?
Please sir i am working on a POS program but i am having issues generating a receipt.please send me the code.
Amazing tutorial on query tuning... thanks a lot