330 Topics
 | |
 | This tutorial demonstrates how to build an AI agent that queries SQLite databases using natural language. You will see how to leverage the [LangGraph framework](https://www.langchain.com/langgraph) and the [OpenAI GPT-4o](https://openai.com/index/gpt-4/) model to retrieve natural language answers from an SQLite database, given a natural language query. So, let's begin without ado. ## … |
| | Good morning to all. I am Vishnu Kumar, MS (Software Engineering) graduate, fresher, 2012 passed out. And i am another one in your way with a dream to develop a game. I had gone through plenty of articles and topics (pinned in this forum too) but i find that, basic … |
| | Hi. I have a local installation of SQLite3 and PHP which runs a small in house PHP application so sql injection is not an issue. I am able to execute the following: if(isset($_GET['deletequote'])) { $qno = $_GET['deletequote']; echo $qno;?><br><?php // for testing $db = new SQLite3('./fi_data.db') or die('Cannot delete quote. … |
 | # Introduction # As we move into 2022, businesses will continue to look for ways to become more data-driven. This means that knowing how to use Structured Query Language, commonly called SQL or 'Sequel', will remain an essential skill for data scientists, analysts, and developers. In this post, we'll provide … |
 | I am trying to come up with an SQL query to return all the records earlier than a certain year with SQLite using DB Browser. I can't seem to come up with the right regex expressipn to use for filtering only the year from a row for comparison, below is … |
| | Helllo guys am trying to build my first ASP.NET application here and I have a **Models** folder and **Controllers** folder. The models folder contains the class for an entity called customer whose properties are to be read from sqlite database. Thee is also a **Pages** folder that contains a folder …  |
 | ## Introduction ## If your Android Application uses Room, then you might have wondered how to prepopulate a Room database. In this tutorial, we will learn how to prepopulate a Room database. ## Goals ## At the end of the tutorial, you would have learned: 1. How to prepopulate a … |
| | I am interested in technology, however I do not wish to go to university and after stumbling upon the MIT Challenge, I have taken it as a proof of concept. Clearly education is changing, and I would like to take a less traditional route. But before I go too far, … |
| | ## Introduction ## One of the best debugging tools in Android Studio is the *live database inspector*. It allows developers to peek at the current state of the database and even run queries against it. In this tutorial, we will learn how to use it to debug a local SQLite … |
 | I have a SQLite database that for some insane reason stores dates as the number of days since 1899-12-31. I want to create a view that will display the date as an actual date. I can calculate a specific date from a specific day number as select date('1899-12-31','Localtime','+44386 day') as … |
| | Create the following table using SQLite database The basic building block of the system. Book: Every book will have BookID, BookTitle, Author, ISBN, Publishers. Employee : Every Employee will have EmployeeID, EmployeeName, FatherName, Designation, Salary Student: Every student will have Registration, StudentName, DOB, Program, Term Create table for issue and …  |
| | I want to make sqlite table like this format: | Matric | Name | GitHub Link | Status | |--------|-------------------------- |---------------------------|--------| | 243340 | Yu Zhixiong | https://github.com/abcde | Yes | | 250634 | Ahmad Afham Bin Noor Azizan | | No | I get two link is first link …  |
| | I'm looking to build a command-line tool that will enable me to read an arbitrary XML file combined with a mapping to fill an existing (arbitrary) SQLite database with data. What I'm looking for are conceptual ideas on how to solve this. I've got a possible theoretical solution in mind, … |
 | Hello. I am making a database using SQLite. Then I need to make an API with functions that returns information about that database. Then I need to print out a report. However, when I try to return an answer to a query using inputs, nothing is returned. I either get …  |
| | I have been trying to solve this error for almost 2 days have tried various posts from multiple places like github, stack overflow, and even daniweb. None have helped so far. So expecting atleast explaination for issue if you don't have answer. So here how I am creating database in … |
 | I'm reading data from SQLite database table. If the SQLiteDataReader encounters a negative double an InvalidCastException is thrown. Here is my code. public void DBToArray() { string stm = "SELECT * FROM mtable"; SQLiteCommand cmd = new SQLiteCommand(stm, sqlcon); SQLiteDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Console.WriteLine( rdr.GetInt32(0) + " … |
 | |
 | Hi, I've written this code which i send below. now i have a listview, and when i click each item in my listview, i want it's related word to be fetched from db and shown in my textview. now it fetches all the data :(. look at the picture, for … |
 | Hello, my code at the minute fetches a record and splits it up into a tuple, this is so each individual element can be displayed in an entry. I am now trying to create a feature which reads what is in the entrybox and updates the record in the database. … |
 | Hi, how would you output the values of a foreign key. For example: if there is a table with two foreign keys (which are linked to other tables), how would you output the values of those foreign keys. |
| | from tkinter import* import tkinter import sqlite3 import sys conn = sqlite3.connect('REVISION CARD.db') c=conn.cursor() def load(): root=Tk() root.title("REVION CARDS") root.geometry("700x400+100+100") w1=Label(root, text="Question") w1.pack() e=Entry(root,width=40) e.pack() w2=Label(root,text="Answer") w2.pack() e1=Entry(root,width=40) e1.pack() toolbar=Frame(root) navbar=Frame(root) N=Button(toolbar, text="next",width=9,command=getNext) N.pack(side=RIGHT, padx=200, pady=5) B=Button(toolbar, text="previous", width=9) B.pack(padx=100, pady=5) toolbar.pack(side=TOP, fill=X) count=IntVar() c.execute("SELECT * FROM topic") list1 = … |
| | Deleting a table data from adminer,It is showing error unable to "unable to open database file"..But command line sqlite3 delete query is working in ubuntu. |
 | Hi hope someone can help me Read sqlite datatable is verry slow I have a listview in detail mode with 45 columns. and a datatable to add, read, delete and update datarows with 45 colums. Only i have a problem to read the datatable and show it all in the …  |
| | Hi All, in sqlite SMALLINT datatype is used to store 2 bytes integer but i didn't see any Unsigned SMALLINT type to support the range(0-65535). Can anybody let me know how to achieve the same.  |
 | Hello I have created two classes one for the user and the other for address every thing is ok and the tables of the two classes created in my database but when i try to initiate a new object from user class i get the below error "sqlalchemy.exc.InvalidRequestError: Mapper 'Mapper|user|user' … |
 | Hi to all! I made a class named “Database” I called openOrCreateDatabase in in its constructor but it was giving error. Then I searched on internet and got a solution that in case of non activity class I should also pass context. Then I passed context but then I am … |
| | I'm a beginning Android Developer trying to learn the file system, etc. I'm hoping to eventually delve into Home Automation and traffic analysis using phones/GPS, but I'm in the beginning arc of this learning curve. My background is mostly C/C++, though I've done some work in Java. I'm not so … |
| | There are 3 JTextfields that are supposed to display info in each one after you click List Info and brings you to a new GUI and you automatically see the info in the JTextFields, but it's not displaying anything. Also I'm using Eclipse and SQLite Manager if that helps. Iogin, … |
| | 1. Crystal Reports SAP Crystal Reports is known as a robust production reporting tool. With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 24 languages. SAP Crystal Reports turns almost any data source into … |
| | Having problems getting my code to run on non dev machines. All machines are win 10 and my code targets .Net 4.6 which is supposed to ship with it. On one machine I had a problem where an exception to do with System.Data.SQLite was thrown and on another I had …  |
| | # Good day to all ..i need help with this..i want to delete and edit the selected row from a listView with the use of alert dialog.i have a bit knowledge of constructing an alert dialog in my class..the problem is the method to call for deleting and editing from … |
| | Hey guise, I have a uni assignment; setting up backend code for a tour company website. Everything's gone swimmingly but I've run into issues implementing a system for rating the tour packages. Implementation for the rating system: user clicks rate button, the rating score is added to a running total … |
| | hi, I am having a problem with adding button on jTable for each data I get from the database. here is what I get from database in SQLite try{ String sql = "select ClassName as 'Class Name', NumberOfStudents as 'Number of Students' from ClassRooms"; pst=conn.prepareStatement(sql); rs=pst.executeQuery(); Data_Table1.setModel(DbUtils.resultSetToTableModel(rs)); if(rs.next){ //code to … |
| | I'm creating a small and simple app to use with my poker league. I've created a small DB that I simply enter the player name, who took them out, and what place they went out in. All of that works just fine. What I need to do is implement the … |
 | I'm trying to load dxf files CAD into a database for searching. Some of these files are huge with hundreds of thousand of separate entites. I've separated the file into the following tables: * drawings * layers * style * entities * points * flags * floats * text The … |
| | I have an old sqlite database that I am no longer going to be using but I want to transfer all of my data to my new mySQL database. I have everyone imported and it all looks good but the problem is when I order my one of my columns … |
| | Im having a problem with updating data in SQLite this is the full code who execute after pressing the button try { PrintWriter writer = new PrintWriter("d:\\"+LBL1.getText()+"\\"+TL3.getText()+"_"+TL2.getText()+"_"+TL4.getText()+"_"+TL5.getText()+"_"+TL1.getText()+".txt", "UTF-8"); writer.println("Invoice Number = "+TL1.getText()); writer.println("Seda = " +TL3.getText()); writer.println("Date = " +TL2.getText()); writer.println("Documental Class = " + TL4.getText()); writer.println("Status = " + …  |
| | Im using this code to get image from SQLITE try{ String sql = "SELECT Photo FROM Pics WHERE InvoiceNumber=?"; pst = conn.prepareStatement(sql); rs=pst.executeQuery(); if(rs.next()){ byte[]imagedata = rs.getBytes("Photo"); format = new ImageIcon(imagedata); ImIc.setIcon(format); } }catch(Exception e){ JOptionPane.showMessageDialog(null, e); } `private ImageIcon format = null;` String filename = null; int s=0; byte[] … |
| | Hi folks. I'm having a problem with VS2010 where suddenly one of my projects is displaying the warning "The referenced component 'System.Data.SQLite' could not be found". All i can find about it in my search is a problem with building both x86 and x64 applications, but my project is only … |
| | Im using NetBeans to create a data entry software for a friend. when I save a data, it create a folder in specified location, and the name of that folder will be different from each other for example.  it pick the Date,Invoice Number, Subject name, and create the … |
| | I'm writing a small backup app, where a folder is selected, zipped, and stored in an SQLite database as a blob along with it's MD5 hash, date, paths ect.... My problem is that when the zipped file is around 600MB+ I get an SQLiteExecption out of memory. The error was …  |
 | I am working on an app where i would scan a coupon and it would find the matching upc in a sqlite database that i have created and place all of the details from that table into a new table for my personal coupon library. I was getting an error … |
| | I've been using [DB Browser for SQLite](http://sourceforge.net/projects/sqlitebrowser/) to peer inside database for debugging. It's been very good and simple to use. However it does not support a DB which has a password. It is fine with DB that I do not have password. Wondering if anyone knows of a db … |
| | Earlier I posted a snippet which showed [how to create a 2 dimensional string array from an SQLite database table](https://www.daniweb.com/software-development/csharp/code/494083/sqlite-database-table-to-2-dimensional-string-array-). This snippet is the reverse, if you will, where we create an SQLite database table from a 2d string array. It should be noted that this code has it's limitations, … |
| | I was working on this function which was quite specific to my project, so thought I'd make it more generic and share it, since I could find very little on the subject in my searching. Code also demonstartes how exceptions can work to your advantage when you know they are … |
 | I am trying to execute the query on server side and send the result to the client but at the time of returning the value to the client the error occurs Am trying to achieve this using RPC Protocol but i could not find out how to send back the … |
| | I need to make an app in Java that must add in a database all the files (with folder structure) from a hard drive. I need to add the metadata of this files as well. What it will be the best aproach ? Using SQLite with multiple tables or Neo4j … |
| | Hello!!I have a database and I want to display its data into a QTreeView in PyQt.The database's column has file paths.I have a problem in filling this treeview with data because it's a database and I'm not sure if it is like working with txt files and because it is … |
| | I just developed an android app having sqlite database so I just want to connect it to the oracle database server at the remote. Pls can someone guide me?  |
 | Hello. When we want to insert a vlue into a table in sqlite, we use this line, right? cursor.execute('INSERT INTO colors Values ("red", "blue")') As we can see above, we want to insert 2 words and we type them as when we are typing whole the codes. But i want …  |
The End.