{"id":8891,"date":"2005-04-25T23:48:33","date_gmt":"2005-04-25T20:48:33","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/2005\/04\/25\/knoda-kdes-front-end-to-databases\/"},"modified":"2005-05-31T23:15:38","modified_gmt":"2005-05-31T20:15:38","slug":"knoda-kdes-front-end-to-databases","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2005\/04\/25\/knoda-kdes-front-end-to-databases\/","title":{"rendered":"knoda – KDE’s front-end to databases"},"content":{"rendered":"\n

knoda<\/a> is one of those cool looking and functionally promising projects. If you are still looking for graphical interface for database management, then try it out. <\/p>\n

Its driver concept allows a uniform connection to different database servers (Dbase\/Xbase<\/a>, MS Access\/Mdbtools<\/a>, Mysql<\/a> , Postgresql<\/a> , SQLite<\/a> or ODBC<\/a>).<\/p><\/blockquote>\n

Did you notice that MS Access was mentioned? Well, here is a little more for you to know:<\/p>\n

New test version knoda 0.7.4-test1 released. With its latest release knoda introduces a driver for MS Access databases (mdb files). Knoda is the first KDE based database frontend reading MS Access databases natively and so it is getting closer to its goal to be a full replacement for MS Access. The driver is based on Mdbtools<\/a>. <\/p><\/blockquote>\n\n","protected":false},"excerpt":{"rendered":"\n

knoda is one of those cool looking and functionally promising projects. If you are still looking for graphical interface for database management, then try it out. Its driver concept allows a uniform connection to different database servers (Dbase\/Xbase, MS Access\/Mdbtools, Mysql , Postgresql , SQLite or ODBC). Did you notice that MS Access was mentioned? … Continue reading knoda – KDE’s front-end to databases<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_links_to":"","_links_to_target":""},"categories":[1,62],"tags":[65,66],"keyring_services":[],"class_list":["post-8891","post","type-post","status-publish","format-standard","hentry","category-general","category-technology","tag-desktop","tag-kde"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":28084,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/10\/13\/database-popularity-index\/","url_meta":{"origin":8891,"position":0},"title":"Database Popularity Index","author":"Leonid Mamchenkov","date":"October 13, 2017","format":false,"excerpt":"Have a look at Red9's Database Popularity Index, which is updated now on a monthly basis.\u00a0 Last year I blogged about a similar study. One thing that is still mind-boggling to me is the total number of different database engines - over 300!\u00a0 I know there is a constant need\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2017\/10\/database-popularity-index-500x286.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":14795,"url":"https:\/\/mamchenkov.net\/wordpress\/2011\/04\/27\/mysql-export-csv-into-outfile-triggers-access-denied-error\/","url_meta":{"origin":8891,"position":1},"title":"MySQL export CSV into OUTFILE triggers “access denied” error","author":"Leonid Mamchenkov","date":"April 27, 2011","format":false,"excerpt":"I came across a weird problem today. \u00a0Gladly, the web is full of solutions, but I'm going to post this anyway, just to have it nearby for the next time. \u00a0I needed to export the results of some query into a CSV file directly from MySQL. \u00a0I prepared my query,\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":25946,"url":"https:\/\/mamchenkov.net\/wordpress\/2016\/03\/16\/aws-database-migration-service\/","url_meta":{"origin":8891,"position":2},"title":"AWS Database Migration Service","author":"Leonid Mamchenkov","date":"March 16, 2016","format":false,"excerpt":"AWS Database Migration Service is yet another one of those tools that you always wished that somebody created, but never actually got to checking if it exists. \u00a0Here is a recent blog post showcasing the functionality. Do you currently store relational data in an on-premises Oracle, SQL Server, MySQL, MariaDB,\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"AWS Database Migration Service","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2016\/03\/dms_connect_endpoints_filled_3-500x409.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":27483,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/04\/04\/how-to-synchronize-wordpress-live-and-development-databases\/","url_meta":{"origin":8891,"position":3},"title":"How to Synchronize WordPress Live and Development Databases","author":"Leonid Mamchenkov","date":"April 4, 2017","format":false,"excerpt":"SitePoint runs through a few options that one can use to synchronize WordPress live and development databases. \u00a0I've linked to \u00a0some of these options before, but it's nice to have them all conveniently together. \u00a0The solutions discussed include WordPress-specific tools: WP Migrate DB Pro WP Sync DB WPSiteSync for Content\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2017\/04\/databases-500x310.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":28562,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/05\/08\/database-flow-modern-self-hosted-web-interface-for-sql-and-graphql\/","url_meta":{"origin":8891,"position":4},"title":"Database Flow – modern, self-hosted web interface for SQL and GraphQL","author":"Leonid Mamchenkov","date":"May 8, 2018","format":false,"excerpt":"Database Flow is a modern, Open Source, self-hosted, web-based tool for working with SQL databases and GraphQL APIs.\u00a0 It supports a variety of the database engines: IBM DB2, Oracle, H2, PostgreSQL, MySQL, SQLite, Informix, and Microsoft SQL Server.\u00a0 It features an advanced SQL editor, query plan analyzer, GraphQL client, schema\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/05\/database-flow-500x281.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":24657,"url":"https:\/\/mamchenkov.net\/wordpress\/2015\/08\/26\/how-does-a-relational-database-work\/","url_meta":{"origin":8891,"position":5},"title":"How does a relational database work","author":"Leonid Mamchenkov","date":"August 26, 2015","format":false,"excerpt":"\"How does a relational database work\" is an excellent (lengthy, technical, but simply written and well explained) article on some of the most important bits inside the relational database. \u00a0It's somewhat of a middle ground between a theoretical database discussion in college and vendor-specific documentation of a database engine. Though\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"databases","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2015\/08\/databases.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/8891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=8891"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/8891\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=8891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=8891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=8891"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=8891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}