<strong>MesaSQLite</strong> makes creating, designing, and altering an SQLite3 database easy. We also use it to edit, summarize, and analyze data for ourselves and clients. Although we build new databases most days, we spend more of our time viewing and editing data. MesaSQLite is set up for this in mind. 

<p>MesaSQLite uses the SQLite3 database engine. Here is an overview of MesaSQLite features: 

<p>Connections: 
<ul> 
	<li>Connect to any database visible on a volume 
	<li>Open a new connection with each new window 
	<li>Do both of the above at the same time 
</ul>Structure: 
<ul> 
	<li>View, add, duplicate, rename, and delete tables 
	<li>View, add, duplicate, rename, edit, and delete fields on tables 
	<li>Specify field type, length, nullable, default value, and autoincrement 
	<li>Add and delete indexes on tables 
	<li>View the Create Table sql syntax for your tables 
</ul>Viewing and Editing Content: 
<ul> 
	<li>Select encoding for viewing your data - encodings: UTF8, Win Arabic, Win Baltic Rim, Win Cyrillic, Win Greek, Win Latin 1, Win Latin 2, Win Vietnamese, K018-R, Shift-JIS, ISO Arabic, SO Cyrillic, ISO Greek, ISO Hebrew, ISO Latin 1, ISO Latin 2 
	<li>Limit the number of records that load upon table selection 
	<li>Suppress autoloading of records upon table selection 
	<li>Build query to limit records using dropdown menus 
	<li>Limit a recordset from a table by selecting a record count and a starting record 
	<li>Set a "Load Last" limit that will load the last "n" records in the table 
	<li>Limit the columns returned in a recordset 
	<li>Sort a recordset by multiple fields 
	<li>Make global changes to many records in a showing recordset 
	<li>Reset column widths for easier viewing after a recordset loads with one click 
	<li>View totals of numeric columns in a recordset with one click 
	<li>Add and edit records directly in the listbox view 
	<li>Delete records directly from the listbox view 
	<li>Multi-select adjacent or non-adjacent rows for deletion or global editing 
	<li>Click and drag in the recordset listbox to select cells and make them available to the clipboard 
	<li>Reorder columns of data using click-and-drag without changing the structure of the table 
</ul>Special Queries: 
<ul> 
	<li>Type any query into the custom query field 
	<li>Read errors and rows returned associated with a custom query 
	<li>Store favorite queries and keep a history of recent queries 
</ul> Forerign Keys: 
<ul> 
	<li>SQLite3 Trigger technology is used to create Foreign Keys whose syntax is stored in the CREATE TABLE suntax of the table. Three triggers are created for each key in order to create and preserve referential integrity between tables 
	<li>Create, view, and edit your Foreign Keys in the Foreign Key tab 
</ul>Exporting and Importing Data: 
<ul> 
	<li>Drop a file containing REALBasic code to generate the database you have built in MesaSQLite 
	<li>Export a proprietary dump to back-up the structure and content of the database 
	<li>Export the content screen, custom query result, or table as a csv, tab, or xls file 
	<li>Import a proprietary dump that can recreate the database from a single file 
	<li>Import any csv, tab, or xls file into a given table 
</ul>

Desert Sand Software

One-Time Purchase

MesaSQLite

SQLite3 database browser, editor and manager.

Create, edit, or restore damaged databases with the help of these awesome handy apps. Enjoy simple graphical frontend and simultaneous access to multiple database systems.

Database

mesasqlite

AI apps use artificial intelligence to automate tasks, analyze data, and deliver smart, personalized solutions.

Adding an extension gives a Safari browser new superpowers. Block ads, translate webpages, or sort your bookmarks — elevate your browsing experience with free or paid Safari add-ons.

Safari Extensions

Select the best browser app to match your needs. We’ve got a wide variety of extensions to simplify your web surfing routine.

Browsing

Keep track of your clients with an easy Customer Relationships Management app. Organizing your customer’s info in one place will help you work smarter, plan better and grow your business faster.

Automatically track and control stock levels. Try inventory management software to make sure your company always has enough stock, invoicing runs easily, and customers remain happy.

Inventory Management

Focus on what’s important for your business and leave boring routines behind. Here you’ll find task managers, time trackers, mind-mappers, business data analyzers, and many more.

Project Management

Improve your website ranking with pro tools. Check our collection of SEO apps to help your site stand out and easily optimize it for search engines.

Make complex business routines easy. Good software can help your company grow, and we’ve got lots of this: from office suites and task managers to specific CRM or SEO solutions.

Business

The mouse pointer is all yours. Highlight it, hide it, manage your cursor through your keyboard, or add special trail effects.

Cursor

Enjoy easier access to what you need through handy widgets. Games, weather, sport — widgets will always keep you posted.

Dashboard Widgets

We own a rich collection of apps to transform your Mac desktop experience. Choose ones to organize files, make screenshots easier, stop sleep time, or adjust your menu bar just the way you want to.

Desktop

Adjust your Mac keyboard your way. Remap it, change shortcuts, add sounds after keystrokes, change your Touch Bar look, or even use a simulation of it if you don’t have one.

Keyboard & Touch Bar

Change the boring black screen of a sleeping Mac into something more captivating. Scenic, neon, space-themed, or something wilder — find your perfect screensaver below.

Screensavers

Light up your desktop with an amazing new wallpaper. Trade the default one into a fresh and vivid aesthetic that fits your personality best.

Wallpapers

Change the way your desktop looks and feels. Browse the curated app collection designed to save time, simplify your Mac experience, or just bring more fun into your daily routine.

Customization

Build Mac automation scripts easier. Sync and automate your AppleScript workflow with time-saving tools in the list below.

AppleScript

Simplify converting the source code with a handy app that does the job effectively. Try compiler or interpreter software to automate your Mac programming routine.

Compilers & Interpreters

Organize your development workflow with the help of  frameworks, plug-ins, or toolboxes.

Components & Libraries

Automate your app development workflow. Try life-saving tools like bug trackers or code testing apps for stress-free debugging.

Debugging

IDE, or integrated development environment, combines common developer tools into a single graphical user interface. Try powerful and lightweight IDE apps.

IDE Software

Learning programming is easier with the help of a good app. We’ve got the list below to help you master Java, Swift, Python, PHP, Objective-C, or other languages.

Manuals & Tutorials

Download the development environment or an HTML editor you’re missing. Make software development easier.

Programming Languages

Elevate your team’s productivity with tracking source code changes to spark faster delivery.

Source Code Management

Choose a web editor to start building websites faster and streamline your development workflow.

Web Development

Improve your workflow to create apps or build websites hassle-free. Here’s our collection of life-saving apps for devs.

Developer Tools

Convert your ebook format, read comic books, or manage your online library. Browse our e-reader app collection that bookworms absolutely love.

E-Readers

Create accurate yet beautiful maps with the geography tools we’ve picked for you. Convert coordinates easily and enjoy access to Geographic Information System (GIS).

Geography

Enhance your writing with these great apps. Always pick the right word with our pro collection of dictionary, spell-checker, or thesaurus tools.

Language Learning

Master new skills with handy tutorial apps that teach you literally everything — from touch typing to the periodic table.

Learning

Use magically smart apps to make calculations easier, create graphs, convert units, solve equations, or handle complex math tricks.

Math

Practice makes perfect. Use medical education software to pass your certification exams or study healthcare terms.

Medical Education

Everyone can master chords. You just need a good music app to do it. Learn any instrument you crave including the guitar, piano, harmonica, ukulele, mandolin.

Music Education

Easily organize academic research citations using massive libraries of quotes.

Reference Management

Research and explore the most complex things on Earth. Get an app to help you study molecular biology, galaxies, crystal structures, or anything science-based.

Science

Use an app to organize your hectic studying routine. Monitor grades, plan your exams, and live a better, more productive student life.

Student

Translate faster using smart translators and text converters that erase language barriers.

Translation

You can’t know everything, but you can grow your knowledge with these educational apps for virtually anything — from languages and music to math or science.

Education

Elevate tracking business expenses with a nice accounting or bookkeeping app.

Accounting

Skip visiting your bank by downloading a banking app that simply does this job for you.

Banking

Automatically create and manage your invoices, get bill reminders, and live a happier, more organized financial life.

Billing

Pick a smart app for basic accounting, scientific computing,  calculating interests, or converting units.

Calculators & Converters

Whether you’re ready to start mining crypto, or just looking for rate trackers and digital wallets, you’re in the right place here.

Cryptocurrency

Create financial dashboards to analyze your business stats and make reliable forecasts.

Financial Analysis

Track stocks and get the latest market updates to make smart investments to help grow your money.

Investment Management

Spend less and save more by managing your daily expenses more effectively.

Personal Finance

Organize your data in beautiful spreadsheets, easily created with an automatic app.

Spreadsheet

Find profit-making opportunities with software that ensures trading stocks is easier than ever before.

Trading

Spending wisely and putting money away helps grow your savings. So let’s kit you out with the essential financial apps to help you count easier, invest better, and make financial predictions more accurate.

Finance

How fast can you react? Test your coordination by helping characters successfully overcome physical challenges.

Action

Explore the fictional worlds of RPG and adventure games, and hunt for hidden gems to make your character stronger.

Adventure

Hop on to play addictive arcade games — from retro classics to space mazes, you’ll find the one for you.

Arcade

Test your thinking and luck with the most popular board games, including chess, dominoes, backgammon,  mahjong, or tic-tac-toe.

Board Games

Play your favorite card game, featuring timeless classics like bridge, poker, or solitaire.

Card Games

Play like a pro: access cheat codes, connect joysticks, or emulate incompatible games with the help of these apps.

Gaming Tools & Utilities

Train your brain and solve the best puzzles we could find on the web.

Puzzles

Feel the speed and be the next champ by playing some exciting racing games.

Racing

Shoot true to take out enemies and leave the gaming battlefield as the only winner.

Shooting

Try living in someone’s shoes and experiencing a new profession, lifestyle, or even another world.

Simulation

Enjoy playing virtual sports with games realistic enough to make you feel ultra-engaged.

Sports

Keep your mind sharp by playing strategy games that make you think one step ahead at all times.

Strategy

Combat and defend to win virtual battles in your new favorite war game.

Give your brain a workout by solving numerous crosswords and addictive word puzzles.

Word Games

Indulge yourself in these fun games and discover new favorites. Our collection covers all game genres.

Games

Sculpt realistic models and create 3D design concepts using smart graphics and rendering tools.

3D Modeling

Whether you need to create simple animated GIFs, or a complex 3D animation, you’ll find the right app below.

Animation

Protect ownership of your creations by using simple watermark makers, media cataloging apps, or other handy apps.

Authorship & Copyright

Automate drafting with CAD (computer-aided design) apps for architects and engineers that simulate how a design looks in the real world.

CAD Software

Easily create books, brochures, or booklets with automatic layouts and professional publishing features.

Desktop Publishing

Create clear flow charts and graphs to present  data in the most visually appealing way possible.

Diagrams & Graphs

Enjoy apps with hundreds of free and premium fonts that will help your artistic creations stand out.

Fonts

Generate icons from images, convert their format, or explore curated icon collections.

Icons

Create beautiful artworks using vector graphic apps with a rich drawing toolset.

Illustration

Master any document in the PDF format. Read, edit, convert, and sign them using life-saving PDF apps.

Unleash your creativity in Adobe Photoshop by adding plugins to enable the use of new effects, filters, or correction tools.

Photoshop Plug-ins

Whether you are a web designer, illustrator, or a graphic artist, you’ll find the right app here. Explore the font and icon packs, CAD and 3D modeling software, PDF converters, Photoshop plug-ins, or others.

Graphic Design

Discover living in peace and harmony with the help of sound therapy apps.

Meditation & Relaxation

Try an app to track your personal calorie count or water balance to live healthier.

Nutrition

Track your workout exercises and enjoy a better yoga experience using smart helper apps.

Workout & Fitness

Get the most out of your wellness lifestyle with great apps to simplify your yoga routine, enhance meditation practice, or just eat healthier.

Health & Fitness

Keep your docs and photos in cloud storage. Share easier, access anywhere, and enjoy extra security for your files.

Cloud Storage

Use special download apps to capture entire websites and their audio or video content. Get torrent clients and management apps to organize your downloads.

Download Managers

Smart email clients will help you discover how much a mailbox can do.

Email Clients

Email Converters

Try smart software to personalize the look of your emails or easily back up your important inbox conversations.

Email Servers

Check out the easiest ways of transferring your files to cloud storage or other external devices.

File Sharing

FTP, or File Transfer Protocol apps, are designed to securely upload and download files directly from servers, which makes files accessible from anywhere with the internet connection.

FTP Software

Listen to live radio stations or record them using smart radio software.

Internet Radio Players

Send instant messages or make video calls with fast and secure chat apps.

Messengers

Use newsreader apps to catch up with the latest news stories and stay up to date with what’s going on worldwide.

Newsreaders

Watch TV on Mac when you want to. Access unavailable  TV channels with the help of handy apps.

Online TV Players

Use remote access tools to control your Mac or help others troubleshoot important issues.

Remote Management

Get instant updates from your favorite websites. Download an RSS reader and never miss a thing.

Create a personal local server or manage your web servers using special software.

Server Software

Experiment with social media interfaces, add new functions, or just share posts more easily.

Social Network Software

Browse our curated collection of messengers, email clients, file managers, and other apps to simplify your online experience.

Internet Utilities

Read QR codes, create your own ones, or scan barcodes using highly-rated reader apps.

Barcode

Bon appétit! Discover new delicious recipes and store your favorite ones using a smart cooking app.

Cooking

If you love brewing, winery, or coffee, you’ll love apps to level up your food and drink skills.

Food & Drink

Digitally lay out your family tree and go explore your ancestral roots!

Genealogy

Try out apps designed solely for children: from coloring booklets to programming for kids, all with parental controls in place.

Kids

What are you interested in? Whatever you answer, we might already have an app for that. Check out our transport, cooking, shopping, weather, or religion apps to simplify your everyday routine.

MesaSQLite: 4.2.7 - 4.1.3