Search the Community
Showing results for tags 'databases'.
-
Hi everyone During the covid lockdown i've decided to finish an old project of mine i started during my education, but never finished due it is so large and abstract, that even the teachers said 'That will never work'. Now that it soon has all the basic features it's current state, i was then wondering if it's actually relevant or not these days due technology moves so quickly. Eitherway, it was really fun to create and a pain in a..., and would sit nice on my portfolio. What i'm seeking now, is to to hear some oppinons on the solution / idea, and what also could be nice to have in such application or general workflows people seek to shorten in daily day that people miss or wished existed. Disclaimer I'm not a pro, or trying to make advertisement for the product, but general interested in the software solution, potential and ideas for improvements if any. Why did i make this software? A friend of mine had an issue at work, where he had to involve many steps and different tools, solutions, and data sources. The process was long from exporting data from different databases based on request, having different applications, filter the data recieved, combine it with some files from a client and filter it again with a script which he had to write himself, before the result came to live. I've managed to shorten this process to few minutes and saved him some work for repeatable tasks as this.. Intro video website What is this software? The software is a datamanagement tool, to merge data from different data sources together. It allows you to connect all your favorit databases in one single application and fetch data from them and combine them if not converting it inbetween the different databases. The application also support's the typical REST, SOAP (ASMX, SVC) and OData API's and soon WZDL files import. The API's has the same use-case as the database connections with few options also known from the POSTMAN if an database connection is not exposed or you simply don't want to work with an databases in general. When having all the data from either API's, and databases, files can be involved in the progress and merged with different connections to an unique export. If in doubt of files, content or verse versa, a simple comparing tool inbetween files vs files, files vs tables etc can be used. Below is an example of an export or manipulation of the data fetched from different sources. Below is also a wished result, if we want the application to write an documentation for where the data came from. Application type It's currently made in WPF, but are looking to convert it into something different in near future. Documentation & download Please see the attached file, or the website Thanks for reading. Kind regards Martin Datamergeeditor DEMO documentation.pdf
-
Hi, I've taken the 'poor guy" approach and I've made a docker image to backup a remote MySQL/MariaDB server into a remote git repository (ie. GitLab, GitHub, etc). I'd like to listen to your opinion on this form of backup, potential security threats, optimization tips, etc And, its free and open source. I'm open to Pull/Merge requests: https://gitlab.com/franciscocb/mariadb-git-backup-docker
-
- programming
- development
-
(and 4 more)
Tagged with:
-
Hi. I am building a web site with NodeJS and as my database I am going to use MySQL and configure it to use nfs server for storing data. Let say I have 2tb of storage in my nfs server. Now 2tb isn't ok for me. I had to add another nfs server with 5tb storage. What my problem is How do I add another server with 5tb of storage to existing server that is with 2tb of storage without stopping the server that is with 2tb storage. And I am not using any cloud provider I am just using servers that are running on my local network. if there is any misunderstanding please correct me because I am new to this. I now to how to scale NodeJS with kubernaties and add more servers to the same cluster as my app growers. But I am confused with adding more storage to a server without stopping my application. "" what I am saying not putting hardrives to the same server but make another server with more storage and connecting it to the server that is running without stopping the application so that the running server can use the other servers storage "".
-
So i want to display some data from a column of a table from the database in a label. i have found a way to display the text in the label from the DB but if the text is too long, only some part of it is displayed.is there a specific number of characters that a label can display?is there a way for me to display all my text from the column of my DB?
-
programming How to view all images stored in database using JSP?
Shammikit posted a topic in Programming
i have 10 images in my database table and i want to display all those images in a jsp page. i have tried this code .it displays the last image in the database only in all 10 places. i have attached a image so that u can see how it appears. only the Toshiba logo which is the last image stored in the DB is showing in all positions. i want to show all the images in descending order. <% Class.forName("com.mysql.jdbc.Driver"); Connection conn = null; conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testdb", "root", "root"); Statement stmt = null; stmt = conn.createStatement(); String query = "select * from products order by ID DESC "; ResultSet rs = null; rs = stmt.executeQuery(query); while(rs.next()){ %> <tr> <% String name = rs.getString("Name"); String Price = rs.getString("Price"); String imge = "viewitemimageservlet?image1"; %> <td><%=name %></td> <td><%=Price %></td> <td> <img src="viewitemimageservlet?<%=imge %> " width="400" height="200" /> } -
i want to display some images in a datagrid view in my client application. the images are located in another computer which acts as the server. the server has the MS SQL server database which stores the image paths that are located in a folder of the server. i want to know if its possible to view these images the way i want but without sending the image file to the client computer. thanks Edit: i want to do this in a C# winforms application
- 12 replies
-
- sql server
- databases
-
(and 1 more)
Tagged with:
-
so i have a table in my sql server that holds the directory path, the image name and another row called name which stores a user input. im able to manually enter a row ID and get the directory path and file name combine them together and assign to another string. without entering manually, i want to get all images from the table and display it i the datagrid one after the other. is there a way to get this done?
-
- microsoft
- sql server
-
(and 1 more)
Tagged with:
-
so i have a datagridview that takes data from database and displays it.i have only two columns but for some reason the datagridview is generating extra columns.i have attached a image which shows it. i want to stop it from making those extra columns and display only the two which has data. how can i dot this?
- 8 replies
-
- microsoft
- visual studio
-
(and 2 more)
Tagged with:
-
i have a column called ID in my table and i have set it to increase by 1 when new data is inserted. when i inserted data like 3 times the ID was 3 but when i added another record instead of showing the ID as 4 it showed 6. i checked my auto increment settings and it was set to increase by 1. i didnt understand what was happening so i dropped the table, made a new one and started entering data. the first time i entered the ID was one but the second time i inserted it showed 4 as ID and the third time in inserted a record ID was 6. what is actually going on? im inserting data using the edit table data mode in sql server however the first time i tried it was using C# and i got the same issue. is this some error in sql server 2014 or am i doing something wrong?
-
sql server Creating a trigger to work on delete in SQL server
Shammikit posted a topic in Programming
so i have a table where i want deleted records to be inserted to another table. how can i achieve this? i have already gone through the internet about this and i have found some codes as well, but i dont understand them. if some one could explain the two examples below it would be very helpful and i will try to make one for myself on my own. ------------------------------------------Example 1 --------------------------------------------------------------- create trigger transaction_state after update on test_archive begin insert into test_me select * from test_archive where Transaction_status = 2; delete from test_archive where Transaction_status = 2; end; -------------------------------------------------------------------------------------------------------------------- ---------------------------------------Example 2 ------------------------------------------------------------------ ALTER TRIGGER [dbo].[HashTags_BeforeDelete] ON [dbo].[HashTags] FOR DELETE AS BEGIN INSERT INTO HashTagsArchive(Id, HashTagId, delete_date) SELECT d.Id, d.HashTagId, GETUTCDATE() FROM deleted d END GO ---------------------------------------------------------------------------------------------------------------------- 3 replies
-
- programming
- microsoft
-
(and 2 more)
Tagged with:
-
sql server Fully uninstalling SQL server 2014
Shammikit posted a topic in Programs, Apps and Websites
so idk how it happened but i think i have installed sql server 2014 twice in my system and i have 2 instances. so i uninstalled the instance that i created and it was the only instance which showed up in the wizard to uninstall it. however after uninstalling that i searched for sql server in my pc and it wasnt there.since there were 2 instances i should still be able to access sql server even after uninstalling one instance right? because i was unable to find it i thought everything got uninstalled so i installed sql server again and when i open it up i still have 2 instances in it! and this time when i try to login to one instance it gave me this Named Pipes Provider, error 40 - Could not open a connection to' SQL Server' error. i found the solution for this online and it was to activate the sql server service which was stopped from services.msc or sql server 2014 configuration manager but it gave me a error saying "the request failed or the service did not respond in a timely fashion". so i have decided to uninstall sql server once again and when i tried to uninstall sql server 2014 64bit from add or remove programs it asked me to uninstall some other sevices first so i uninstalled all sql server 2014 services that showed up in add or remove programs and when i try to uninstall sql server 2014 64 bit it gave me this error shown in the screenshot. what is going on? How do i fully uninstall sql server 2014 from my PC and so that i can start off with a fresh install? Any help would be greatly appreciated as i have wasted 2 days trying to get this thing running. Thanks. -
Hey so I've learning to program and have got up to a part where you start messing around with databases. I'm using a local Microsoft Access Database file but keep pulling up an error. Anyone know why?
-
im facing this weird situation where my ID columns which has been set to auto increment skips numbers, jumps numbers by 2 or 3 and sometimes it jumps a number then later goes back to the number which was missed and continues from there. once my ID even jumped by 1000. i googled this problem and i found this solution where i have to go to SQL server service, go to start up parameters and insert -t272. i have also posted a screenshot on this. i hope i did that right. after that it didnt jump a 1000 but it still keeps doing this jumping by 2 and 3 and sometimes going back. i have posted a screenshot on this as well. it happen in random tables and at random times so i have not find it possible to detect a pattern and tell when it will happen again
-
- sql server 2012
- programming
-
(and 2 more)
Tagged with:
-
FYI: head to the second paragraph for a visual aid Hey guys! I've finally found some answers to my previous questions and have finally bin able to start the project I needed to get too work! I've gotten about 25% of the way to a proper working version but some of the things I am running into includes, creating and writing to a .csv file as well as everytime new information is entered in, it will add it automatically to said .csv file, a way to parse through the .csv file as kind of as a data look up but also is it possible to write to a different .csv file if I wanted to seperate the information from one database to another, I have included a image down below. Just a heads up everything is working at this time except for this .csv database. I'm not askign for an exact line of code on how all this will work but I am asking for a kick in the write direction where I should be looking for in documentation and all that sorts of fancy stuff. For all those who cannot make sense of what I am asking about in the above section this is a visual aid with some information on what the hell I am talking about. Green Box - So for this box I want this information to be sent to a different database that I can look through afterwards that it will always save to assuming no other similiar information is present ie.) Information is entered --> Checks to see if there is any other similiar information, like the name and the number --> Saves new information to the file or if it is already present it ignores saving information to the file. Red Box - For this box we can just ignore it as I already have this part saving into the Blue Box with no current issues, but I did draw it in to show you where the information was coming from for Blue Box. Blue Box - Now this information I want too be able to save this into a different .csv file from what Green Box is saving its information too. It would be nice is for every time the program is loaded you have an option to load a .CSV file or create a new one. Although I do understand this might not be the best and fastest solution it may be just one file that is the best and the fastest. I thank you all for any help you can provide and insight on what should be optimized and maybe even suggest a new way to go about tackling my database issue.
-
My Remote user: 192.168.0.112 (windows, PHP with mysqli) My Mysql Server (ubuntu 20.04 lts) 192.168.0.105\ My Commands i have run so far: CREATE DATABASE web_search; USE web_search; CREATE TABLE IF NOT EXISTS `web_info` ( `id` int(11) NOT NULL, `meta_title` varchar(100) NOT NULL, `meta_description` varchar(300) NOT NULL, `site_url` varchar(300) NOT NULL, `platform` varchar(300) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=latin1; CREATE USER 'remote4'@'192.168.0.112' IDENTIFIED BY 'mypass'; GRANT ALL PRIVILEGES ON web_search.* TO 'remote4'@'192.168.0.112'; I get the Error "actively refused connection" On my Config.php: <?php $user = 'remote3'; $password = 'mylegitpasswod''; $database = 'web_search'; $db = new mysqli('192.168.0.105',$user,$password,$database,3306); ?> my error
-
I've designed a database schema for an inventory management system. Some tables are missing but this is the most important one.For the same product, product type, manufacturer and supplier are repeated so there is redundancy (there are also products with the same name from different manufacturers like bread, fruit etc...)which is why I designed this Which one is better and how should I improve them?
-
I'm working on a software on my own and I need to talk to someone that has experience in c#, servers and database's. I am working on the software alone and don't have experience with servers and databases and I need to talk to someone about it. I will explain to you personally what I'm trying to do with servers and databases and hopefully you can point me in the right direction. Info: I'm looking to add a login system to my software and possibly a product key system also. I need to know how I can go about saving the login data and how it all works because I've never done SQL or anything to do with servers. Thanks for reading and hopefully someone can help me Kind regards, Scott D.
-
For my final project (as part of graduation exams) i have to create a website of my own liking. I chose a football league site, that will display scores, teams, referees, stadium etc. My professor asked me how am i going to do it, using php or databases. I don't know which to choose as i didn't do anything like this ever. Q:What do you think how should i do it and do you have any sites or forums that will be able to help me? I look forward to your help and i am grateful
-
im making a website using java jsp and the users accessing the website should be able to upload images to it.i want to know what data type i should be using to store images. im familiar with sql server and it has a data type called image but mysql doesnt. so any help would be great. Thanks
- 9 replies
-
- jsp
- sql server
-
(and 3 more)
Tagged with:
-
if i want to display a image from database in a form, and if database is located in one PC and if the forms are located on another PC, is it possible for me to have class files in the same computer where database is in and call these class files in the forms through a network and use to display things like images and text in the forms?
-
In the enterprise software world, the “review” ecosystem and journalism around what to buy is highly overdue to be disrupted (beyond media creation / editing software, which I know is already a strong suit of LTT). Here are a few reasons to illustrate why this is an area LTT could disrupt: Trusted content creators like Gartner and their “magic quadrant” control the narrative and operate closer to a traditional media environment and closed off CIO network Expensive licenses make enterprise software difficult to obtain for the average Joe to review until they’re working at a company and forced to use it Sending effective feedback to these companies is highly difficult; they like to fly under the radar avoid negative PR and increase stranglehold on their customers (looking at you Oracle) Pricing can be opaque because of companies that literally don’t list their price and non-public enterprise license agreement deals, ie companies don’t share what they paid to others Need for technical know-how to properly test this kind of software LTT viewership is aging and moving into IT positions that support this kind of software; as a trusted brand LTT could move into this space along with the viewership Seeing poorly built enterprise software that viewers normally wouldn’t see every day would be fun to watch; bonus points if “WTF why would I pay for this??” Comparing open source alternatives with their expensive enterprise cousins The challenge would be, making this topic cool enough to make a good return out of it in views. I think it could be done given the reach of LTT’s draw, and making the videos interesting, could bring in experts from the outside, could point the software to funny use cases Examples of enterprise software to review (broad in scope): SAP Tableau Salesforce AWS Oracle (Java, DB, Cloud, etc) SAS Azure Power BI MS Dynamics Office 365 OneDrive Various unheard of IBM products OpenShift Watson Cognos Google Cloud Platform G-suite Workday UltiPro Cornerstone LMS ServiceNow NetSuite Pivotal Broadcom / CA stuff GIS (Esri, ArcGIS) …and more
- 17 replies
-
- enterprise software
- databases
-
(and 4 more)
Tagged with:
-
I have been trying to figure out any mistake for a couple of hours now but i have failed to identify any. there's another insert query in my program written similarly to this and that works fine but this one doesnt work.here's the code public void new_employee(string company, string name, string description, string img, string pos, string key) { try { SqlCommand cmd = new SqlCommand(); SqlConnection cn = new SqlConnection(@"Server = .\;Integrated Security = True"); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@com", company); cmd.Parameters.AddWithValue("@nam", name); cmd.Parameters.AddWithValue("@des", description); cmd.Parameters.AddWithValue("@image", img); cmd.Parameters.AddWithValue("@post", pos); cmd.Parameters.AddWithValue("@ekey", key); cmd.Parameters.AddWithValue("@date", DateTime.Now); cmd.Connection = cn; cmd.CommandText = "INSERT INTO business_db.dbo.Sponsor(Branch_name,Name,Description,Image,Position,Emp_key,Date) VALUES (@com,@nam,@des,@image,@post,@ekey,@date); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); } catch (Exception ex) { } } ----------------------------The data base table look like this--------------------------------- ID int (set to auto increament) Branch_name varchar(100) Name varchar(100) Description varchar(MAX) Image varchar(100) Position varchar(100) Emp_key varchar(50) Date date
- 4 replies
-
- c sharp
- sql server
-
(and 1 more)
Tagged with: